Re: [SQL] date range to set of dates expansion

[Gary Stainburn]

On Thursday 19 January 2012 16:50:53 Steve Crawford wrote:
> I'm sure most here would recommend moving to 9.1 rather than 8.4. Better
> performance, cooler replication functionality, more advanced in-place
> upgrade capabilities for future upgrades, a couple years longer before
> end-of-life, advances to windowing functions and other SQL commands and
> much other goodness.
>
> Cheers,
> Steve

Thanks for this Steve.  I would have had a look at whatever the latest version 
is before proceeding. However, I'm running this on an old Fedora 9 box and 
like to stick to using RPM's.

Can I upgrade to 9.1 on a  FC9 system using RPM's?

Also, the last time I did a server upgrade (FC4 to the FC9 system) upgrading 
apache, PHP and postgresql broke so many things in my applications it was 
painful. Can anyone suggest ways I can soak test my systems before upgrading 
the live system?

-- 
Gary Stainburn
Group I.T. Manager
Ringways Garages
http://www.ringways.co.uk 

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Token separation

[Jasen Betts]

On 2012-01-16, Tim Landscheidt  wrote:
> Tom Lane  wrote:
>
>>> [ "0x13" is lexed as "0" then "x13" ]
>
>>> Is this behaviour really conforming to the standard?
>
>> Well, it's pretty much the universal behavior of flex-based lexers,
>> anyway.  A token ends when the next character can no longer sensibly
>> be added to it.
>
> I know, but - off the top of my head - in most other lan-
> guages "0abc" will then give a syntax error.

 In most other languages "0 abc" would also be a syntax error.
 
 0and  doesn't give a syntax error in php
 
 eg: 
 
-- 
⚂⚃ 100% natural


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql