suggestion?
Thank you!
--
Marco Lazzeri [ n o z e S.r.l. ]
Via Giuntini, 25/29 - 56023 Navacchio - Cascina (PI)
Tel +39 (0)50 754380 - Fax +39 (0)50 754381
mailto:[EMAIL PROTECTED] - http://www.noze.it
---(end of broadcast)---
TIP 3: if posting/reading
Does exist a syntax in PostgreSQL for integer (INT) number ranges?
It could be useful for queries like
"SELECT * FROM table WHERE id IN (range from 1 to 20)"
Thank you!
Marco
---(end of broadcast)---
TIP 2: you can get off all lists at once with t
there at most one row in each
> table?
>
> > On Fri, Jan 23, 2004 at 05:15:56PM -0300, Martín Marqués wrote:
> >> Mensaje citado por Marco Lazzeri <[EMAIL PROTECTED]>:
> >>
> >> > I want to write a query on table 'main' that if 'id_
Il ven, 2004-01-23 alle 19:59, Ezra Epstein ha scritto:
> > I've got a table called 'main' described as follow
> >
> > CREATE TABLE main (
> > id_other_table INT,
> > value CHAR
> > );
> >
> > and a table called 'other' described as follow
> >
> > CREATE TABLE other (
> > id INT PRIMARY KEY,
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 unsuccess
And what about restricting UPDATE/DELETE queries too. Can I still use
VIEWs?
Bye
Il mer, 2004-05-19 alle 05:06, Joshua D. Drake ha scritto:
> You could use a view and give group rights to a particular view.
>
> Josué Maldonado wrote:
>
> > Hello list,
> >
> > This is an inventory system where
