[SQL] Inquiry From Form [pgsql]

2003-10-14 Thread Bram
Hello, I\'m looking for info about Join conditions in Postgre\'. I\'m head developer of ikonboard and we\'re trying to optimise it, with joins but how does this work in postgre can i download a manual anywhere? Thanks in advanced, Bram Wijnands Head IB Developer [EMAIL PROTECTED] -

Re: [SQL] Inquiry From Form [pgsql]

2003-07-03 Thread scott.marlowe
On Thu, 3 Jul 2003, Bruno Wolff III wrote: > On Wed, Jul 02, 2003 at 16:26:09 -0300, > Chris Schneider <[EMAIL PROTECTED]> wrote: > > I know this is basic, but couldn\'t find and in a hurry to know the answer. When > > interfacing with PostgreSQL through PSQL, it appears that DML statements ar

Re: [SQL] Inquiry From Form [pgsql]

2003-07-03 Thread Bruno Wolff III
On Wed, Jul 02, 2003 at 16:26:09 -0300, Chris Schneider <[EMAIL PROTECTED]> wrote: > I know this is basic, but couldn\'t find and in a hurry to know the answer. When > interfacing with PostgreSQL through PSQL, it appears that DML statements are > auto-commited, that is, a change I make in one

Re: [SQL] Inquiry From Form [pgsql]

2003-07-02 Thread David Witham
test_table Table "public.test_table" Column | Type | Modifiers +-+--- col1 | integer | HTH. David -Original Message- From: Chris Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 July 2003 05:26 To: [EMAIL PROTECTED] Subject: [SQL] Inquiry From F

[SQL] Inquiry From Form [pgsql]

2003-07-02 Thread Chris Schneider
I know this is basic, but couldn\'t find and in a hurry to know the answer. When interfacing with PostgreSQL through PSQL, it appears that DML statements are auto-commited, that is, a change I make in one session is seen from another without the original session issueing a COMMIT. Is this a re

Re: [SQL] Inquiry From Form [pgsql]

2003-03-02 Thread Greg Stark
Jack Kiss <[EMAIL PROTECTED]> writes: > 1)Do you have a function which is similar to Oracle\'s DECODE. Yes > 2) Can you extract day of week (Monday,etc) from yours date functions. Yes Check out the "Date/Time Function and Operators" and the "Conditional Expressions" sections of this: http://

[SQL] Inquiry From Form [pgsql]

2003-03-01 Thread Jack Kiss
Dear Sir/Madam, I would like to find out two things: 1)Do you have a function which is similar to Oracle\'s DECODE. 2) Can you extract day of week (Monday,etc) from yours date functions. Kind Regards, Jack Kiss ---(end of broadcast)--- TIP 3: if po