arrays, not set

From: "Vladimir V(dot) Zolotych" <gsmith(at)eurocom(dot)od(dot)ua>
To: pgsql-admin(at)postgresql(dot)org
Subject: arrays, not set
Date: 2000-05-04 06:53:35
Message-ID: 39111E6F.26960708@eurocom.od.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Herbert Rabago Ambos 2000-05-04 08:01:58 Re: backup of my database...
Previous Message Vladimir V. Zolotych 2000-05-04 06:43:41 Re: Removing NOT NULL Contraint

Browse pgsql-general by date

  From Date Subject
Next Message Greg Brzezinski 2000-05-04 09:20:13 connect via libpq.dll using Ip adress...
Previous Message Jurgen Defurne 2000-05-04 06:49:22 Re: What do you think?