Re: SQL WHERE: many sql or large IN()

From: Chris <dmagick(at)gmail(dot)com>
To: tom <tom(at)tacocat(dot)net>
Cc: Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: SQL WHERE: many sql or large IN()
Date: 2007-04-20 07:56:39
Message-ID: 46287237.5050607@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

tom wrote:
> This is some good stuff and I can use the explain analyze going forward.
> But I can't get these VALUES queries to work.
>
> I checked and I am on version 8.1. but I think from the docs that I
> should still be able to do this.

Multiple VALUES was introduced in 8.2 as others mentioned so you can't
use it in 8.1.

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2007-04-20 08:10:47 Re: dollar-quoting trouble
Previous Message Andrew Toth 2007-04-20 07:42:58 Re: Download source