Re: checking SQL statement/subexpression validity

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: lists(at)zara(dot)6(dot)isreserved(dot)com (David Garamond)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: checking SQL statement/subexpression validity
Date: 2005-02-09 03:10:17
Message-ID: 200502090310.j193AIVk002290@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Art Fore 2005-02-09 04:17:41 Backup restore does not work
Previous Message Rick Schumeyer 2005-02-09 03:07:58 how to delete from a view