>Table ACL:
>Attribute |Type | Modifier
>---+-+
> uniqid| varchar(12) | not null
> date_created | timestamp | not null
> date_modified | timestamp | not null
> read | boolean | not null default
Ed Loehr wrote:
>
> Jason Vasquez wrote:
> > Basically, I'd like to set up an ACL-like property for each record. A table
> > could be strucured like this:
> >
> > Table ACL:
> >Attribute |Type | Modifier
> > ---+-+
> > un
Jason Vasquez wrote:
>
> I've looked through the documentation, but I've not found anything that
> addresses this situation. Is this possible with PostgreSQL? Or maybe there is
> a better way to accomplish what I want to do?
>
> Basically, I'd like to set up an ACL-like property for each record
Chris Jones wrote:
>
> NOTICE: Index error_interface_idx: NUMBER OF INDEX' TUPLES (226766) IS NOT THE SAME
>AS HEAP' (226765)
> NOTICE: Index error_ewhen_idx: NUMBER OF INDEX' TUPLES (226766) IS NOT THE SAME AS
>HEAP' (226765)
Hope this was not already answered...
I believe it means that th
I've looked through the documentation, but I've not found anything that
addresses this situation. Is this possible with PostgreSQL? Or maybe there is
a better way to accomplish what I want to do?
Basically, I'd like to set up an ACL-like property for each record. A table
could be strucured lik
Andrzej Mazurkiewicz wrote:
>> And what is MATCH FULL?
> [Andrzej Mazurkiewicz] I would not like to speculate perhaps
>somebody else knows exact answer.
MATCH FULL:
Either all referencing columns must be null, or all must have values.
MATCH PARTIAL:
"if any columns are non-null, th
You have to use two backslashes, as the preprocessor will take the first
one out (I may be wrong about this, but I remember reading something
similar a few months ago on this list.) Also, remember that you have to
send two slashes to PostGres, which may mean that you need to use 4 slashes
in
Try :
select target, avg(reaction_time) from data_table group by target;
Haven't tested it, but it should be close to what you're looking for.
At 02:14 PM 3/3/00, G. Anthony Reina wrote:
>I'd like to return an average for one item in my database grouped by
>another item. For example,
>
>The tab
Hi,
I'm using regular expressions in 6.5.3 version but i cannot find the
character to escape special caracters as ?, $, ^.
I've tried with \ but it doesn't works.
Example: i want to find the row with the value 'fisica?' and i do:
select title from libros where title ~* 'fisica\?' ;
but i also
Hi, all.
I'm relatively new to PostgreSQL, but I've been quite impressed with
it so far. This may be due to too much experience with MySQL. :)
I'm currently getting this error on my nightly vacuum. These two
indices (as you may have guessed already) are on columns named
interface and ewhen, o
10 matches
Mail list logo
