On Fri, Jul 3, 2009 at 8:32 PM, Guy Flaherty wrote:
>
>
> On Fri, Jul 3, 2009 at 7:44 PM, Jennifer Trey wrote:
>
>> Hi,
>>
>> I would like to run a query and group several rows based on a phone
>> number.
>>
>> However, the same phone number might
On Fri, Jul 3, 2009 at 7:44 PM, Jennifer Trey wrote:
> Hi,
>
> I would like to run a query and group several rows based on a phone number.
>
> However, the same phone number might have a prefix on occasion, example :
>
> name | phone_number
> --
> james | 123456
> james | 00441
certain range.
>>
>>
If all you want to do is check to see if someone's birthday is coming up
within a set period, then this query will return true or false:
SELECT extract(doy FROM TIMESTAMP '1970-07-20')
BETWEEN
extract(doy FROM now()) AND
extract( doy FROM CURRENT_DATE +30)
Guy Flaherty
[]
[]
On Sun, Jun 28, 2009 at 1:52 PM, Adam Rich wrote:
> Hello,
> I have a table with a DATE field "birth_date". The data obviously contains
> various dates in the past, such as 07/04/1970. In my query, I need to
> retrieve the person's "next" birthday. In other words, for the example date
> 07/04/
be much appreciated! ;-)
> <http://www.postgresql.org/mailpref/pgsql-general>
You would need to do a dump restore when upgrading from 8.2.9 to 8.3.
Guy Flaherty
