On Tue, Feb 03, 2009 at 04:21:29PM +0530, Gurjeet Singh wrote: > > > > _query_latest_version = rhnSQL.Statement(""" > > SELECT nvl(version, 0) version, version orig_version, cert, > > TO_CHAR(issued, 'YYYY-MM-DD HH24:MI:SS') issued, > > TO_CHAR(expires, 'YYYY-MM-DD HH24:MI:SS') expires > > FROM rhnSatelliteCert > > WHERE label = :label > > ORDER BY version DESC NULLS LAST > > """) > > > > So rhnSatelliteCert needs some mappings, I think the TO_CHAR looks > > usable in PostgreSQL, is it just the nvl that needs to change here? > > > > You can see quite a few other queries in the file, I don't know how > > many of them are going to end up getting called but this is the first > > one I hit. > > As Jan said, nvl() is provided by Orafce. But I'd recommend using ANSI > standard COALESCE() for the purpose as that is available in both Oracle and > Postgres. > > BTW, I am more worried about the NULLS LAST part of the query. As I have > mentioned in the > Worklog<https://fedorahosted.org/spacewalk/wiki/PostgresWorklog>, > this feature is available in Postgres only since 8.3. And I have no freakin' > clue how to get the same behaviour in PG < 8.3!
How about order by decode(version, null, 1, 0), version ? -- Jan Pazdziora Satellite Engineering, Red Hat _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel