Re: table alias nor valid for delete

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: table alias nor valid for delete
Date: 2002-04-09 20:54:21
Message-ID: 20020409135149.R98278-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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>]

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-04-09 20:56:23 Re: Sub-selects taking way too long..
Previous Message Tom Lane 2002-04-09 20:53:16 Re: Why does this not work? (keyword 'TEXT')