Hi, when I use the psqlODBC with MS-Access I´ve got not problems but when I
try to use it with Oracle the next message appears:
SELECT * FROM "ORACLE"."TABLITA"@POSGRES
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Generic Connectivity Using ODBC]Record &SQLREC has no fields. Loading
failed
ORA-02063: preceding 2 lines from POSGRES
Altougth I´ve got already fields in the tables, I´ve tried with differnt
kind of datatypes varchar char int numeric....but the problem persist
Any Idea???
Thanks in advance
-----Mensaje original-----
De: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Enviado el: Miércoles, 23 de Julio de 2003 10:35 a.m.
Para: Jason Topaz
CC: pgsql-novice@postgresql.org
Asunto: Re: [NOVICE] Struggling with set-returning functions, seeking advice
Jason Topaz <topaz@panix.com> writes:
> 1) Note that my first attempt (view "ranges_setview_broken", referring
> to a pgplsql set function "make_rows") fails. But when I make a
> second function with identical signature, but in language 'sql'
> (it's just a passthrough to my original pgplsql function), suddenly
> the server error goes away. This seems strange to me.
It's an implementation artifact: plpgsql uses a different implementation
method to return sets than sql does. sql's method works both in SELECT
lists and in FROM, plpgsql's only works in FROM.
The trouble with a set function in FROM is that it can't take any parameters
that are extracted from other tables in the query. There has been some talk
of fixing that by implementing SQL99's LATERAL() syntax, but we haven't yet
wrapped our heads around exactly what would be involved there. In the
meantime, the way you're doing it is probably as good as you're going to
get.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly