Re: [INTERFACES] PL/pgSQL Syntax Problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hubert Palme <hubert(dot)palme(at)web(dot)de>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] PL/pgSQL Syntax Problem
Date: 2002-03-04 23:03:16
Message-ID: 9049.1015282996@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces pgsql-sql

Hubert Palme <hubert(dot)palme(at)web(dot)de> writes:
> ERROR: query "SELECT * INTO daten FROM telefon WHERE t_lfd_nr = $1 "
> isn't a
> SELECT

> Why isn't this a SELECT??

Get rid of the INTO ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-03-04 23:05:43 Re: storing intermediate results in recursive plpgsql functions
Previous Message Tom Lane 2002-03-04 23:01:27 Re: trying to upgrade and keep large object IDs intact...

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jeroen T. Vermeulen 2002-03-04 23:55:09 libpqxx "robust" transactions
Previous Message Jeremy Buchmann 2002-03-04 22:47:33 Re: help understanding libpq++

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-03-04 23:05:07 Re: Uniqueness of rule, constraint, and trigger names
Previous Message Tom Lane 2002-03-04 22:58:22 Re: CREATE FUNCTION and LANGUAGE 'C'