Re: column name does not exist - Mailing list pgsql-novice

From Michael Wood
Subject Re: column name does not exist
Date
Msg-id 5a8aa6680907281005t6ed34352ja382fbe40988a501@mail.gmail.com
Whole thread Raw
In response to column name does not exist  (abhinav mehrotra <talk2abhinav@gmail.com>)
List pgsql-novice
Sorry, meant to send this to the list:

2009/7/28 abhinav mehrotra <talk2abhinav@gmail.com>:
[...]
> On doing: select * from ab (1,4,"exam","abhi",5);
>
> I get an error : ERROR: column "exam" does not exist.
>
>
> Any idea what is going wrong? Am I missing something?

Use single quotes.  Otherwise PostgreSQL thinks you're talking about
columns instead of literal strings:
- Hide quoted text -

select * from ab(1, 4, 'exam', 'abhi', 5);

--
Michael Wood <esiotrot@gmail.com>

pgsql-novice by date:

Previous
From: abhinav mehrotra
Date:
Subject: column name does not exist
Next
From: "Jason Stelzel"
Date:
Subject: Synchronizing the schema of two PostgreSQL databases