Re: [SQL] CIdr query qestion

2007-07-10 Thread Jesper K. Pedersen
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 ---

Re: [SQL] Vacation days

2007-06-26 Thread 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. :) >

Re: [SQL] OT: OpenDatabase Model ?

2006-08-16 Thread Jesper K. Pedersen
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.

[SQL] OT: OpenDatabase Model ?

2006-08-16 Thread Jesper K. Pedersen
"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 ---

Re: [SQL] PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly

2006-05-27 Thread 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

Re: [SQL] Merging rows into one result?

2006-03-11 Thread 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: > > > >

[SQL] Merging rows into one result?

2006-03-11 Thread Jesper K. Pedersen
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

Re: [SQL] How to implement Microsoft Access boolean (YESNO)

2006-01-22 Thread Jesper K. Pedersen
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

[SQL] How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ?

2006-01-22 Thread Jesper K. Pedersen
(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