Re: [SQL] [GENERAL] Working with dates

2007-07-05 Thread Ranieri Mazili
Original Message Subject: [GENERAL] Working with dates From: Ranieri Mazili <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], pgsql-sql@postgresql.org Date: 5/7/2007 16:00 Hello, I need to do the following select: Number of days of month - weekends - holydays So this query will ret

[SQL] Working with dates

2007-07-05 Thread Ranieri Mazili
Hello, I need to do the following select: Number of days of month - weekends - holydays So this query will return the number of days that people can work Look that I have the holydays in one table, it's bellow: CREATE TABLE holidays ( id_holidays serial NOT NULL, dt_holiday date, holiday_d

Re: [SQL] separating improperly grouped page views

2007-07-05 Thread Jeff Frost
On Sun, 17 Jun 2007, Jeff Frost wrote: On Mon, 18 Jun 2007, Tom Lane wrote: Jeff Frost <[EMAIL PROTECTED]> writes: [ umpteen million iterations of: ] -> Limit (cost=0.00..367.09 rows=1 width=8) -> Index Scan Backward using page_view_stamp_idx on page_view

Re: [SQL] 'comp.databases.theory'

2007-07-05 Thread Michael Holzman
On 6/27/07, Dmitry Turin <[EMAIL PROTECTED]> wrote: i want to discuss in newsgroup 'comp.database.theory'. Please, prompt address of any NNTP-server ? http://groups.google.com/group/comp.databases.theory/topics?lnk=gschg ? -- Regards, Michael Holzman ---(end of

[SQL] 'comp.databases.theory'

2007-07-05 Thread Dmitry Turin
Good day. My name is Dmitry Turin, i want to discuss in newsgroup 'comp.database.theory'. Please, prompt address of any NNTP-server ? Dmitry Turin SQL4 (4.1.0) http://sql40.chat.ru HTML6 (6.1.0) http://html60.chat.ru Computer2 (2.0.2) http://computer20.chat.ru