Em 28/07/2012 19:41, Tom Lane escreveu:
Edson Richter writes:
If I do apply trim over the substring, no spaces are removed, and I
cannot understand why.
...
But using the regular expression matching "^\s*" and "\s*$" works, and
spaces are removed:
I think what this means is that what you say a
Em 28/07/2012 20:18, Adrian Klaver escreveu:
On 07/28/2012 03:20 PM, Edson Richter wrote:
Em 28/07/2012 13:46, Adrian Klaver escreveu:
On 07/27/2012 04:58 PM, Edson Richter wrote:
I've a select with the following expression:
select trim(both ' ' from substring(rslinha2 from 5 for position('(-
On 07/28/2012 03:20 PM, Edson Richter wrote:
Em 28/07/2012 13:46, Adrian Klaver escreveu:
On 07/27/2012 04:58 PM, Edson Richter wrote:
I've a select with the following expression:
select trim(both ' ' from substring(rslinha2 from 5 for position('(-)'
in rslinha2)-6))
from ...
prob
Edson Richter writes:
> If I do apply trim over the substring, no spaces are removed, and I
> cannot understand why.
> ...
> But using the regular expression matching "^\s*" and "\s*$" works, and
> spaces are removed:
I think what this means is that what you say are runs of spaces are no
such t
Em 28/07/2012 13:46, Adrian Klaver escreveu:
On 07/27/2012 04:58 PM, Edson Richter wrote:
I've a select with the following expression:
select trim(both ' ' from substring(rslinha2 from 5 for position('(-)'
in rslinha2)-6))
from ...
problem is that the spaces are not being removed f
On Fri, Jul 27, 2012 at 02:13:31PM +1000, Chris Angelico wrote:
> On Fri, Jul 27, 2012 at 9:57 AM, Chris Angelico wrote:
> > On Fri, Jul 27, 2012 at 9:53 AM, Bruce Momjian wrote:
> >> You might want to look at the hackers list thread I started about the
> >> same topic a week before your post:
>
On 07/27/2012 04:58 PM, Edson Richter wrote:
I've a select with the following expression:
select trim(both ' ' from substring(rslinha2 from 5 for position('(-)'
in rslinha2)-6))
from ...
problem is that the spaces are not being removed from either side. What
would be wrong?
FYI th
Thanks to all who have posted. Your comments are very helpful.
On Jul 26, 2012, at 11:04 AM, Vincent Veyron wrote:
> I had assumed the OP _was_
> using Postgres already, and that this was being challenged by the new
> manager.
Yes, that is accurate. The new manager is not familiar with OSS and P
* Abraham, Danny wrote:
FATAL : could not read directory base": Invalid argument
8.2.4 on Windows. Service will not start. Any idea
The data directory path should be quoted, but yours only has the
closing quote. The parameter should look like
-D "S:\ome\path\goes\here"
, so add
