Re: [SQL] sql doubts

2000-06-07 Thread Frank G Hahn
On Wed, 7 Jun 2000, Gustavo Henrique wrote: Ad 1) SQL = Structured Query Language :) TSQL is an extention of SQL that includes support for queries against temporal databases. VALID/TRANSACTION TIME and SEQUENCED/NONSEQUENCED queries. If you would like more info on temporal databases try ht

Re: [SQL] Pg/PLSQL Errors!!

2000-05-30 Thread Frank G Hahn
Hi You need to make the call_handler and create the language plpgsql. Assuming postgres is installed in /usr/local/pgsql Example: -- Setup -- define the languages and the associated handlers CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C