Postgres Pro
Downloads
Home   >   mailing lists

Re: need help to write a function in postgresql - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: need help to write a function in postgresql
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2082E6ED9@exadv11.host.magwien.gv.at
Whole thread Raw
In response to need help to write a function in postgresql  ("Madhu.Lanka" <mlanka@avineonindia.com>)
List pgsql-admin
Tree view 
Madhu.Lanka wrote:
> Can u please help to write a function for the following scenario?

> "select [...] from [...] where [...] and p.name=? and p.password=?"

Don't use "?" for the parameters.
Use "$1" for the first parameter and "$2" for the second.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: "francescoboccacci@libero.it"
Date:
Subject: SSL SYSCALL error: EOF detected
Next
From: Tom Lane
Date:
Subject: Re: SSL SYSCALL error: EOF detected