[SQL] BLOB

Hallo. I was just searching documents how to define BLOB in postgres and couldn't find any hints. Could somebody enlighten me? Postgres is 7.0.3. I need to insert into DB text field more than 8000 symbols and there is no way, I can upgrade postgres to 7.1, so only way I see it's possible, is by d

[SQL] DISTINCT ON () with UNION

How can you use a distinct on () including the whole union. eg select distinct on (valutaid) valutaid, short from valuta UNION select landid, land from land order by valutaid; table: valuta valutaidvaluta 1 USD 2 SEK table: land landid land 1

Re: [SQL] DISTINCT ON () with UNION

[EMAIL PROTECTED] writes: > How can you use a distinct on () including the whole union. In 7.1 you can write select distinct ... from (select ... union select ...) ss; regards, tom lane ---(end of broadcast)--- TIP 3: if p

[SQL] how to remove ?

How to remove from this mailing list ? > "Marc Lamothe" <[EMAIL PROTECTED]> writes: > > The subnet_number column is a varchar(16) which I assume you can compare > > with a text data type, which is what host() returns. > > Are you on a pre-7.1 Postgres release? host() is buggy before 7.1 --- >