On Thu, Dec 22, 2022 at 11:37:22AM -, haman...@t-online.de wrote:
> 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)
Please don't use char datatype:
https://wiki.postgresql.org/wiki/Don't
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 bec
