| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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? |