alues that I want to
> exclude! (And I don't found how to do the opposite!)
>
Couldnt you do a :
select count(ip_addr), ip_addr from wi_log_network where not (ip_addr
<< '10.10.0.0/16') group by (ip_addr);
Best regards
Jesper K. Pedersen
---
On Tue, 26 Jun 2007 13:04:14 -0400
Wei Weng <[EMAIL PROTECTED]> wrote:
> On Monday 25 June 2007 15:22, Susan Young wrote:
> > Hi Wei,
> > That's OK - Enjoy!
> > Susan
> >
> > Wei Weng wrote:
> > > Can I take next week off?
> > >
> > > Thanks!
> > >
> > > Wei
>
> hi, susan, a change of plan. :)
>
Andrew Sullivan wrote:
On Wed, Aug 16, 2006 at 06:12:06PM +0200, Jesper K. Pedersen wrote:
Doing a bit of database work for several friends (golf clubs and so on)
I was very keen to start using a sort of "standard" and not least open
database model with predefined tables.
"standard".
The ODBM group that was offering this was found at
http://www.opendatabasemodel.com - but the past long time it seems like
it is dead.
Anyone know of any other projects similar to this?
Any suggestions that may help is welcome.
Best regards
Jesper K. Pedersen
---
ch time, it
will read the date adding the nextval(...) at read time and then sort
it.
Best regards
Jesper K. Pedersen
On Sat, 11 Mar 2006 17:43:37 +0100
Andreas Kretschmer <[EMAIL PROTECTED]> wrote:
> Jesper K. Pedersen <[EMAIL PROTECTED]> schrieb:
>
> > Is it possible to use SQL to merge data into one result?
> >
> > A theorethical example to explain:
> >
> >
wonder if there is any functions to "merge" data (sort of
concat'ing).
A normal: select information from tbl_test where id=1
would result in the rows
Yo
Stay put
I would like a single row result in the format of:
Yo Stay put
Any ideas on this?
Best regards
Jes
On Sun, 22 Jan 2006 15:46:11 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Jesper K. Pedersen" <[EMAIL PROTECTED]> writes:
> > I am have some difficulties converting the Microsoft field of type
> > YESNO (which is a simple boolean true/false) to something t
(1) as
"text" fields.
This mean that I am not able to use the built-in form input fields for
the "YESNO" field type.
Anyone with any ideas on how to get around this?
Thank's
Jesper K. Pedersen
---(end of broadcast)---
TIP