Craig Ringer wrote:
>
> It sounds like what you want is to have a table that contains a full
> history of records, plus another table that contains only the records
> from the first table that were inserted/updated today.
>
> If that is what you mean, there are several ways to do it, with
> di
Andrew Sullivan wrote:
On Fri, Aug 15, 2008 at 09:54:26PM +0200, Tino Wildenhain wrote:
looks like you want to write your own "powerdns" ? :-)
http://www.powerdns.com/
Oh, right, I forgot they use a SQL back end. They do EDNS0, too :)
(Note, however, that if you plan to deploy DNSSEC you're
I have a table with an array column (tags text[]) which I want to
select from via ANY and RegExes.
SELECT tags from zettelkasten where 'Sozialpsychologie' ~* any(tags) order by
ident;
delivers 7 rows
SELECT tags from zettelkasten where 'SoziALPSychologie---FOOBARBAZ' ~*
any(tags)
order by
"Stefan 'Kaishakunin' Schumacher" <[EMAIL PROTECTED]> writes:
> I have a table with an array column (tags text[]) which I want to
> select from via ANY and RegExes.
> SELECT tags from zettelkasten where 'Sozialpsychologie' ~* any(tags) order by
> ident;
Did you look at the matches? I suspect
On Fri, 22 Aug 2008 18:34:53 -0600
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> Glad you got your problem resolved. I have to admit I tend to
> mostly use psql to interact with postgres. Nothing against
> PGAdmin III, it's good software. I just tend to feel more comfy
> scripting things than cl
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> The problem is that one of these two statements is using the abbrev
>> meaning and the other is using the timezone meaning.
> Is this a TODO?
We already fixed it:
2008-07-07 14:09 tgl
* src/backend/utils/adt/: date.c, times
On Sat, 23 Aug 2008 11:41:41 -0600
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> On Sat, Aug 23, 2008 at 10:28 AM, Ivan Sergio Borgonovo
> <[EMAIL PROTECTED]> wrote:
> > On Fri, 22 Aug 2008 18:34:53 -0600
> > "Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> >
> >> Glad you got your problem resolved. I
On Sat, Aug 23, 2008 at 10:28 AM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]> wrote:
> On Fri, 22 Aug 2008 18:34:53 -0600
> "Scott Marlowe" <[EMAIL PROTECTED]> wrote:
>
>> Glad you got your problem resolved. I have to admit I tend to
>> mostly use psql to interact with postgres. Nothing against
>>
Can someone suggest how I could speed up the execution of this query?
select count(distinct attendance.studentid)
from attendance
where attendance.studentid not in (select studentid from attendance where auth
not in('C','E','F','G','H','I','M','N','O','R','S','T','U'))
It returns the correct re
* Ivan Sergio Borgonovo wrote:
> On Fri, 22 Aug 2008 18:34:53 -0600
> "Scott Marlowe" <[EMAIL PROTECTED]> wrote:
>
> > Glad you got your problem resolved. I have to admit I tend to
> > mostly use psql to interact with postgres. Nothing against
> > PGAdmin III, it's good software. I just tend to
On 23/08/2008 18:56, Marc Balmer wrote:
> The pgadmin3 version I use has some annoying bugs: If I want to
> add privileges to an object, it does not show me all roles in
> the corresponding drop down box.
This isn't a bug - by default it shows group roles only. If you want to
see users as well, y
>
> select count(distinct attendance.studentid)
>
> from attendance
>
> where attendance.studentid not in (select studentid from attendance where
> auth not in('C','E','F','G','H','I','M','N','O','R','S','T','U'))
>
>
I am tired a lot now, but isn`t it the same as:
select count(distinct attendanc
12 matches
Mail list logo
