Postgres Pro
Downloads
Home   >   mailing lists

Re: table alias nor valid for delete - Mailing list pgsql-general

From Stephan Szabo
Subject Re: table alias nor valid for delete
Date
Msg-id 20020409135149.R98278-100000@megazone23.bigpanda.com
Whole thread Raw
In response to table alias nor valid for delete  (Jean-Luc Lachance <jllachan@nsd.ca>)
List pgsql-general
Tree view 
On Tue, 9 Apr 2002, Jean-Luc Lachance wrote:

> Hi all,
>
> I can't specify an alias for the table I want to delete from.
>
> Is this a bug or is that behavior mandated by the SQL standard?

Pretty sure it's at least SQL 92 spec...

<delete statement: searched> seems to have the form of:
DELETE FROM <table name> [WHERE <search condition>]

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why does this not work? (keyword 'TEXT')
Next
From: Stephan Szabo
Date:
Subject: Re: Sub-selects taking way too long..