Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/PGSQL - character varying as function argument - Mailing list pgsql-general

From Tom Lane
Subject Re: PL/PGSQL - character varying as function argument
Date
Msg-id 15617.1222436860@sss.pgh.pa.us
Whole thread Raw
In response to PL/PGSQL - character varying as function argument  ("Chris Baechle" <bangular@gmail.com>)
List pgsql-general
Tree view 
"Chris Baechle" <bangular@gmail.com> writes:
> When I try to run it with:
> select user_checkCredentials("asdf");

> I get the error:
> ERROR:  column "asdf" does not exist

You're confused about single quotes (literal strings) versus double
quotes (identifiers).

            regards, tom lane

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: PL/PGSQL - character varying as function argument
Next
From: Raymond O'Donnell
Date:
Subject: Re: PL/PGSQL - character varying as function argument