Re: Serials in where clause

On Mon, 5 Jul 2004, j0rd1 adame wrote:

> Im having trouble whith a Serial Primary key that i cannot use in a where
> clause
>
> here is what i did
>
> ixmati=# create table jordi(
> ixmati(# "jordi_idPK" serial NOT NULL,
> ixmati(# jordi_nombre varchar);
> NOTICE:  CREATE TABLE creará una secuencia implícita "jordi_jordi_idPK_seq"
> para la columna "serial" "jordi.jordi_idPK"
> CREATE TABLE
> ixmati=# alter table only jordi
> ixmati-# add constraint "jordi_idPK" primary key ( "jordi_idPK");
> NOTICE:  ALTER TABLE / ADD PRIMARY KEY creará el índice implícito "jordi_idPK"
> para la tabla "jordi"
>
>
> Here is the error
> ixmati=# select * from jordi where jordi_idPK = 1;
> ERROR:  column "jordi_idpk" doesn't exists

You created the column with double quotes, so when you want to refer to
it, you should use double quotes as well ("jordi_idPK" = 1)