DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=hiFiAiDAlh7VBbK/Tlg4tKWYXAP5a2XInMPEZJyZ6OadQ9eK82Mkgulr+HL0aOveix
	fMaffjz28+T243/z5L6y2/vp4JoEdZpW+807DfUgEew2vOZH1P32ngv/fdGb4+mT+krc
	BUAeD90+DNTpCbAjOjPjo0J5jU3UTBH43WuL4=
MIME-Version: 1.0
In-Reply-To: <14477.1274969142@sss.pgh.pa.us>
References: <AANLkTiklp-KIa3BSvnVmHWMQFd7fgnYeviSxo1RoQa3W@mail.gmail.com>
	<14477.1274969142@sss.pgh.pa.us>
Date: Fri, 28 May 2010 09:32:40 +0200
Message-ID: <AANLkTinHaKeMsi6WDBqa_wHlL5xK8isjKSp41shrz8gZ@mail.gmail.com>
Subject: Re: Do not understand "SETOF RECORD" - therefore can not use
	ODBC-link
From: Harrie Rodenbach <marktenveiling@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

2010/5/27 Tom Lane <tgl@sss.pgh.pa.us>:
> Harrie Rodenbach <marktenveiling@gmail.com> writes:
>> =3D =A0oratest=3D# select odbclink.query(1, 'SELECT * FROM mytable') as
>> result(id int4, t text, d decimal); =3D =A0ERROR: =A0syntax error at or =
near
>> "(" =3D =A0LINE 1: ...bclink.query(1, 'SELECT * FROM mytable') as
>> result(id int4, ...
>
> You need that to be select * from odbclink.query ...
> the "as" business is only allowed in FROM clause.
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0regards, tom lane
>
That did the trick, thank you Tom. Next problem will be described in a
new thread.

--=20
Met vriendelijke groet / with kind regards,

Harrie Rodenbach