trouble writing plpgsql - Mailing list pgsql-general

From hamann.w@t-online.de
Subject trouble writing plpgsql
Date
Msg-id wolfgang-1221222123722.A0128333@linux-tuxedo
Whole thread Raw
Responses Re: trouble writing plpgsql
List pgsql-general

Hi,

I want to make a function to parsetext and return key-value pairs
create or replace function extractinfo (text) returns table (key char[1], val text) 
language plpgsql as $$

I first tried
declare
xx record;
begin
....
xx.key = ....; xx.val = ....;
return next xx:

This is not possible because xx needs to know its structure before the fields can be assiged to.
Could I declare xx as having these fields in the first place, do Ineedto create a type for key, val
first?

Wolfgang Hamann 




pgsql-general by date:

Previous
From: Rainer Duffner
Date:
Subject: Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: trouble writing plpgsql