Re: KEYEXISTS function - Mailing list pgsql-novice

From Tom Lane
Subject Re: KEYEXISTS function
Date
Msg-id 4146.1025802744@sss.pgh.pa.us
Whole thread Raw
In response to KEYEXISTS function  (April L <april@i-netco.com>)
List pgsql-novice
April L <april@i-netco.com> writes:
> In an old DOS database program I programmed in for years, there was a handy
> function called
> KEYEXISTS("value",index)

There's a perfectly standard EXISTS predicate in SQL ... why not
use that?
    EXISTS(SELECT 1 FROM table WHERE column = 'value')

            regards, tom lane



pgsql-novice by date:

Previous
From: "caroline kenny"
Date:
Subject: Carraige Return issue
Next
From: Jason Friedman
Date:
Subject: user-defined functions/triggers; cannot dump