Re: [SQL] CIdr query qestion

2007-07-10 Thread Jesper K. Pedersen
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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

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. :) Instead of the whole week, I

[SQL] OT: OpenDatabase Model ?

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

[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 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: tbl_test ( id integer, information varchar(25)) id

[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 9: In versions below 8.0

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 that is compatible with PostgreSQL. Assume