Postgres Pro
Downloads
Home   >   mailing lists

Re: checking SQL statement/subexpression validity - Mailing list pgsql-general

From Mike Nolan
Subject Re: checking SQL statement/subexpression validity
Date
Msg-id 200502090310.j193AIVk002290@gw.tssi.com
Whole thread Raw
In response to checking SQL statement/subexpression validity  (David Garamond <lists@zara.6.isreserved.com>)
Responses Re: checking SQL statement/subexpression validity
List pgsql-general
Tree view 
> I need to check whether a SQL subexpression (to be used in WHERE
> clause), e.g.:

I've never tested it from Perl, but could you use 'explain select....'
to see if it parses?  It won't actually execute it if it does.
--
Mike Nolan

pgsql-general by date:

Previous
From: "Rick Schumeyer"
Date:
Subject: how to delete from a view
Next
From: Art Fore
Date:
Subject: Backup restore does not work