Re: column name does not exist

From: Michael Wood <esiotrot(at)gmail(dot)com>
To: abhinav mehrotra <talk2abhinav(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: column name does not exist
Date: 2009-07-28 17:05:19
Message-ID: 5a8aa6680907281005t6ed34352ja382fbe40988a501@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Sorry, meant to send this to the list:

2009/7/28 abhinav mehrotra <talk2abhinav(at)gmail(dot)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(at)gmail(dot)com>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jason Stelzel 2009-07-28 17:44:11 Synchronizing the schema of two PostgreSQL databases
Previous Message abhinav mehrotra 2009-07-28 16:41:07 column name does not exist