Re: Rewriting select statements

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Phil Cairns <phil(at)pagaros(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Rewriting select statements
Date: 2009-10-30 23:32:57
Message-ID: dcc563d10910301632g1447b7dco43f390c7b25c84e7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 30, 2009 at 2:07 PM, Phil Cairns <phil(at)pagaros(dot)com(dot)au> wrote:
> I want to have the server do this:
>
> If the query has no where clause, use a where clause of "where 1=0".
>
> Is this possible?

Anyway to add a 'limit 1' to the end of the query somewhere on the app
side? Like Tom said, this app sounds retartded.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message db de 2009-10-30 23:39:54 Re: pg_start_backup question
Previous Message Guillaume Lelarge 2009-10-30 23:12:08 Re: [GENERAL] CREATE TABLE LIKE and SERIAL