Re: [SQL] NEED HELP COPY TO DYNAMIC OUTPUT FILE

Pavel Stehule writes: > COPY in plpgsql are not allowed. I think it will work if you use an EXECUTE. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] NEED HELP COPY TO DYNAMIC OUTPUT FILE

2009/8/30 Tom Lane : > Pavel Stehule writes: >> COPY in plpgsql are not allowed. > > I think it will work if you use an EXECUTE. > >                        regards, tom lane > I didn't test it. regards Pavel Stehule -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes

[SQL] Searching for byte values within a bytea field

Hi all, I got stuck with a problem. I have a table that stores binary content into a bytea field. Now, I would like to be able to search for specific byte sequences, such as '48545450' ('HTTP'). I can execute a "SELECT myfield FROM mytable WHERE myfield LIKE '%HTTP%' ", but I cannot do the same wh