Re: [SQL] SELECT with WHERE clause by column number

2006-12-18 Thread Ragnar
On mán, 2006-12-18 at 09:17 -0800, Carlos Santos wrote: > > SELECT id FROM myTable WHERE column-number = 'value'; > (PS: The id column is the primary key of myTable). > > That is a select using column number in the WHERE clause what don't > exists in SQL. > > I need this because there's a situa

Res: [SQL] SELECT with WHERE clause by column number

2006-12-18 Thread Carlos Santos
All my columns have the same data type: text. So it's much easier. Carlos Henrique Iazzetti Santos Compels Informática Santa Rita do Sapucaí - MG www.compels.net - Mensagem original De: Richard Huxton Para: Carlos Santos <[EMAIL PROTECTED]> Cc: Lista PostgreSQL SQL Enviadas: Segun

Re: [SQL] SELECT with WHERE clause by column number

2006-12-18 Thread Aaron Bono
On 12/18/06, Carlos Santos <[EMAIL PROTECTED]> wrote: Hi! I need to make a query like this: SELECT id FROM myTable WHERE column-number = 'value'; (PS: The id column is the primary key of myTable). That is a select using column number in the WHERE clause what don't exists in SQL. I need this

Re: [SQL] SELECT with WHERE clause by column number

2006-12-18 Thread Richard Huxton
Carlos Santos wrote: SELECT id FROM myTable WHERE column-number = 'value'; (PS: The id column is the primary key of myTable). That is a select using column number in the WHERE clause what don't exists in SQL. I need this because there's a situation in my program where I don't have the column

[SQL] SELECT with WHERE clause by column number

2006-12-18 Thread Carlos Santos
Hi! I need to make a query like this: SELECT id FROM myTable WHERE column-number = 'value'; (PS: The id column is the primary key of myTable). That is a select using column number in the WHERE clause what don't exists in SQL. I need this because there's a situation in my program where I don't

[SQL] Requirement for PostgreSQL Database Developer

2006-12-18 Thread Mark
Hi , Location: San Diego, CA [You can also TeleCommute but you have to be on the client side for 2 Weeks in a month] Duration: 6+ months. This is Mark with ProV International, This email is in regards to the requirement we have with one of our direct client in San Diego, CA.