469,106 Members | 2,250 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

Check a value in array

Hi all.

In _PostgreSQL 7.3.5_, I have to check if a value is in an array.

I've got an array of dates (date[]) in a table and I would like to
perform queries like:

SELECT * FROM table WHERE date IN dates_array;

I've tried using array_contains_date (contrib/array_iterator.sql)
function unsuccessfully:

SELECT array_contains_date(dates_array, date);

WARNING: plpgsql: ERROR during compile of array_contains_date near line
5. ERROR: missing .. at end of SQL expression

Anyone can help me?
Thanks,
Marco
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
0 1066

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Adrian Parker | last post: by
2 posts views Thread by Edward | last post: by
5 posts views Thread by Steve Wylie | last post: by
9 posts views Thread by chutsu | last post: by
17 posts views Thread by Klaas Vantournhout | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.