Re: Passing a variable from the user interface to PostgreSQL

On 2011-01-21, Chris Campbell <ccampbell@cascadeds.com> wrote:
> --_000_453A24085F801842AEA8D0B6B269065D45E2521023HDMCcdslocal_
> Content-Type: text/plain; charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> Using:
> Windows 7 64bit
> VB.net 2010
> The latest devart.data.PostgreSQL (.net data connection)
> PostgreSQL 9.0.2
>
> Hi all,
>
> Question: Is there a way to pass a variable from an application's user inte=
> rface to the database such that it would be visible inside a database trigg=
> er and any corresponding function call?


you can embed the extra value in an sql comment and retrieve
it with current_query()

"-- this is extra value
delete from sometable where thiscolumn='thatvalue';"

works in 8.4

--
⚂⚃ 100% natural