arrays, not set

Started by Vladimir V. Zolotychalmost 26 years ago2 messagesgeneral
Jump to latest
#1Vladimir V. Zolotych
gsmith@eurocom.od.ua

Hello all

Does anybody know the way to:

1) Get count of elements in postgres array? E.g. for column of
a type TEXT[] for example?

2) Check the column (field) wasn't set during tuple creation? E.g.

CREATE TABLE foo (a INT4, b TEXT);

INSERT INTO foo (b) VALUES ('asdf');

Field 'a' wasn't set, how I can check that in SELECT?

Thanks

#2Greg Brzezinski
gregb@amg.gda.pl
In reply to: Vladimir V. Zolotych (#1)
connect via libpq.dll using Ip adress...

In Win95 (4.00.950 B):

In c++ builder:

I can't connect to postgresql when hostname = 'ip adress',
when hostname = 'name of host, (greg.home.pl)' works fine

In Win98 - IP adress and hostname forks fine

What can I set or change in Win95 to connect to postgres using
idadress??

--Greg--