Re: [SQL] select based on multi-column primary keys

On Tue, Jan 23, 2007 at 01:07:19PM -0800, codeWarrior wrote: > No... its a table constraint using a unique, implicit index on the listed > columns. . Sure. But since these get added as table constraints after dump anyway, I'm not sure I see why it makes a difference. In any case, the point is

Re: [SQL] select based on multi-column primary keys

No... its a table constraint using a unique, implicit index on the listed columns. . PRIMARY KEY ( column [, ...] ) The PRIMARY KEY table constraint is similar to the PRIMARY KEY column constraint. As a table constraint, PRIMARY KEY allows multiple columns to be defined in a parenthetical exp

Re: [SQL] Odbc configuration on Localhost

Ezequias Rodrigues da Rocha wrote: Hi list, Is there any tip to set a localhost connection on the windows odbc configuration to postgresql ? I am using 127.0.0.1 and localhost and notthing. Any suggest ? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

[SQL] Odbc configuration on Localhost

Hi list, Is there any tip to set a localhost connection on the windows odbc configuration to postgresql ? I am using 127.0.0.1 and localhost and notthing. Any suggest ? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincere

Re: [SQL] How to query by column names

John Summerfield wrote: Jeff Frost wrote: On Tue, 23 Jan 2007, Josh Williams wrote: From: Jeff Frost <[EMAIL PROTECTED]> On Mon, 22 Jan 2007, Richard Ray wrote: ... That's definitely part of it. I'm assuming the above is an abridged example and the OP is doing something dynamic with the q

Re: [SQL] How to query by column names

Jeff Frost wrote: On Tue, 23 Jan 2007, Josh Williams wrote: From: Jeff Frost <[EMAIL PROTECTED]> On Mon, 22 Jan 2007, Richard Ray wrote: ... That's definitely part of it. I'm assuming the above is an abridged example and the OP is doing something dynamic with the query. The real trouble