Re: [GENERAL] PGS 7.4.x PREPARE statement

2005-02-24 Thread Geoffrey KRETZ
Tom Lane wrote: Geoffrey KRETZ <[EMAIL PROTECTED]> writes: I was wondering when a PREPARE statement is check. (ie : is it normal that the following statement doesn't return an error : PREPARE stmnt AS "") ? Hm? regression=# PREPARE stmnt AS &quo

[GENERAL] PGS 7.4.x PREPARE statement

2005-02-24 Thread Geoffrey KRETZ
Hi, I was wondering when a PREPARE statement is check. (ie : is it normal that the following statement doesn't return an error : PREPARE stmnt AS "") ? Geoffrey Kretz Four J's Development Tools ---(end of broadcast)--

Re: [GENERAL] PGS 7.2 : Insert with wrong number of values did not

2005-02-21 Thread Geoffrey KRETZ
Scott Marlowe wrote: On Mon, 2005-02-21 at 09:49, Geoffrey KRETZ wrote: Scott Marlowe wrote: On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote: Hi, I've got a question about a difference beetween PGS 7.2 and PGS 7.4 behaviours. With PGS 7.2 : INSERT INTO table (col1, col2) V

Re: [GENERAL] PGS 7.2 : Insert with wrong number of values did not

2005-02-21 Thread Geoffrey KRETZ
Geoffrey KRETZ wrote: Scott Marlowe wrote: On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote: Hi, I've got a question about a difference beetween PGS 7.2 and PGS 7.4 behaviours. With PGS 7.2 : INSERT INTO table (col1, col2) VALUES (val1) doesn't fail With PGS 7.4 : INSERT INTO t

Re: [GENERAL] PGS 7.2 : Insert with wrong number of values did not

2005-02-21 Thread Geoffrey KRETZ
Scott Marlowe wrote: On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote: Hi, I've got a question about a difference beetween PGS 7.2 and PGS 7.4 behaviours. With PGS 7.2 : INSERT INTO table (col1, col2) VALUES (val1) doesn't fail With PGS 7.4 : INSERT INTO table (col1, col2) VA

[GENERAL] PGS 7.2 : Insert with wrong number of values did not fail

2005-02-21 Thread Geoffrey KRETZ
Hi, I've got a question about a difference beetween PGS 7.2 and PGS 7.4 behaviours. With PGS 7.2 : INSERT INTO table (col1, col2) VALUES (val1) doesn't fail With PGS 7.4 : INSERT INTO table (col1, col2) VALUES (val1) failed Is it a known bug ? Thx. Geoffrey KRETZ Four J's De

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Geoffrey KRETZ
Bruno Wolff III wrote: On Mon, Aug 16, 2004 at 18:08:44 +0200, Geoffrey KRETZ <[EMAIL PROTECTED]> wrote: Hello, For the purpose of QA testing, I need a 7.3.X version of postgreSQL for unix (linux i686) but I can't find it on the postgre website. Is it still possible to find

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Geoffrey KRETZ
P.S. The original request was posted as a reply to another thread. This is not a nice thing to do. It messes up the archives and can hide the fact that your request is new, causing some people who could have helped you to ignore it. I'm sorry for that, I don't mind to bother anyone (I've just r

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Geoffrey KRETZ
Devrim GUNDUZ wrote: Hi, On Mon, 16 Aug 2004, Devrim GUNDUZ wrote: For the purpose of QA testing, I need a 7.3.X version of postgreSQL for unix (linux i686) but I can't find it on the postgre website. ftp.postgresql.org/postgresql/source/ Sorry for the typo. It should be: ftp.postg

[GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Geoffrey KRETZ
Hello, For the purpose of QA testing, I need a 7.3.X version of postgreSQL for unix (linux i686) but I can't find it on the postgre website. Is it still possible to find such an old version of pgs available for download ? Thx in advance Geoffrey Kretz - Four J's Develop

Re: [GENERAL] Question on INSERT statement

2004-07-19 Thread Geoffrey KRETZ
Richard Huxton wrote: Geoffrey KRETZ wrote: I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a launching the following request : INSERT INTO temp_tab VALUES (1,2,3) It will insert the values in the three first row whereas with informix or db2 for exemple, it will return an

Re: [GENERAL] UPDATE statement

2004-07-19 Thread Geoffrey KRETZ
Richard Huxton wrote: Geoffrey KRETZ wrote: Hello, Is it a way to make the following UPDATE statement work with PGS 7.4 (UNIX) : UPDATE dbit2 SET (dbit2_key,dbit2_c10,dbit2_vc200) = (ABS(-1),NULL,'xx') WHERE dbit2_key=1 Or am I force to use the following syntax : UPDATE dbit2 SET

[GENERAL] UPDATE statement

2004-07-19 Thread Geoffrey KRETZ
bit2_vc200 = 'xx' WHERE dbit2_key=1 Geoffrey KRETZ - Four J's Development Tools ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] Question on INSERT statement

2004-07-19 Thread Geoffrey KRETZ
ow whereas with informix or db2 for exemple, it will return an error. So is that normal ? Geoffrey Kretz - Four J's Development Tools ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregi