[GENERAL] FOR from query - is it a bug ?

I have function (below) that returns values in table format. But when source table ( xxx.logic_list_item ) is empty I've got following message in log: "row number -1 is out of range 0..-1" Is it a error message ? To be honest I do not know how to handle situation when source table is empty, what s

Re: [GENERAL] How to hide NOTICE messages in psql.exe ?

> might also be interested in psql's -q option (or "\set QUIET"). I use -q but I've got e.g Z:\>psql.exe -q -d ff -h localhost -p 5432 -U postgres 0

[GENERAL] How to hide NOTICE messages in psql.exe ?

Hi I use psql.exe program under windows and I would like that program will hide all NOTICE messages. Is there any psql.exe parameter ? Because of big number of NOTICE messages is very hard to find errors. Michal Szymanski http://blog.szymanskich.net ---(end of broadcast)

Re: [GENERAL] Why my cursor construction is so slow?

> CREATE OR REPLACE FUNCTION alias( >v_mask alias.mask%TYPE, >) RETURNS INT8 AS Sorry my mistake it should be: CREATE TABLE alias ( alias_id BIGSERIAL PRIMARY KEY, mask VARCHAR(20) NOT NULL DEFAULT '',