John R Pierce wrote:
> Tomas Studva wrote:
>> My case is WIN XP SP 2 and also when applied SP3. My system has only
>> one speciality as I know, that is I have windows installed on F
>> partition.
>>
>> I was installing on path F:\Program Files\PostgreSQL\8.4 and also
>> tried C:\Program Files\
It is not working also for dir "F:Programs\PostgreSQL".
Tomas
John R Pierce wrote:
>
> Tomas Studva wrote:
>> My case is WIN XP SP 2 and also when applied SP3. My system has only
>> one speciality as I know, that is I have windows installed on F
>> partition.
>>
>> I was installing on p
Tomas Studva wrote:
My case is WIN XP SP 2 and also when applied SP3. My system has only
one speciality as I know, that is I have windows installed on F
partition.
I was installing on path F:\Program Files\PostgreSQL\8.4 and also
tried C:\Program Files\PostgreSQL\8.4, problem is probably
I don't know what SQL2008 says about SUBSTRING, but SQL2003 says in
ISO/IEC 9075-2:2003 (E), 6.29 , General Rules,
5), page 261:
d) If R [the regular expression] does not contain exactly two
occurrences of the two-character sequence consisting of E [the escape
character], each immediately fol
Hi all gurus,
I've encountered on my computer this bug. I will try to describe all what I
have discovered till now.
1, this bug happened a few times before and wasn't resolved:
bug 5130 -
http://www.mail-archive.com/pgsql-bugs@postgresql.org/msg24810.html
bug 5222 -
http://archives.pos
Hi all gurus,
I've encountered on my computer this bug. I will try to describe all what I
have discovered till now.
1, this bug happened a few times before and wasn't resolved:
bug 5130 -
http://www.mail-archive.com/pgsql-bugs@postgresql.org/msg24810.html
bug 5222 -
http://archives.pos
This is test message. Please ignore it.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
"Roman Kononov" writes:
> test=# select substring('34' from '(2|3)#"4#"' for '#');
> substring
> ---
> 3
> (1 row)
Hmm. I guess we need to translate ( and ) to non-capturing parens.
> test=# select substring('^' from '#"^#"' for '#');
> substring
> ---
>
> (1 row)
> test=#
The following bug has been logged online:
Bug reference: 5257
Logged by: Roman Kononov
Email address: kono...@ftml.net
PostgreSQL version: 8.4.2
Operating system: GNU/Linux x86_64
Description:wrong results of SUBSTRING with SQL regular expressions
Details:
test=# se
Greg Stark writes:
> But that still seems a bit more complex than ideal. Would it be
> reasonable to have a tinterval() constructor which takes timestamptz
> data types?
No, because that would be encouraging people to use tinterval ;-).
That type needs to die.
If Jeff doesn't finish his range-ty
On Sat, Jan 2, 2010 at 1:37 PM, hubert depesz lubaczewski
wrote:
> CONSTRAINT overlapping_times EXCLUDE USING GIST (
> box(
> point( extract(epoch FROM from_ts at time zone 'UTC'),
> extract(epoch FROM from_ts at time zone 'UTC') ),
> point( extract(epoch FROM to_t
hubert depesz lubaczewski writes:
> 3rd insert fails (correctly), but I have doubts about its error message,
> which was:
> psql:z.sql:18: ERROR: conflicting key value violates exclusion constraint
> "overlapping_times"
> DETAIL: Key (box(point(date_part('epoch'::text, timezone('UTC'::text,
Hi,
I tried to use exclusion for time ranges, with this table and data:
CREATE TABLE test (
from_ts TIMESTAMPTZ,
to_ts TIMESTAMPTZ,
CHECK ( from_ts < to_ts ),
CONSTRAINT overlapping_times EXCLUDE USING GIST (
box(
point( extract(epoch FROM from_ts at time zone
13 matches
Mail list logo
