[rt-devel] A bit of oracle clue?

Jesse jesse at fsck.com
Wed Mar 21 19:11:28 EST 2001


The problem appears to be that oracle can't SELECT DISTINCT 
if there are CLOBS in the row to be returned. Ugh. this is going to suck.

On Wed, Mar 21, 2001 at 07:07:13PM -0500, Alex Pilosov wrote:
> > Heya all,
> > 
> >         So I've run into a minor issue with oracle. The following
> > chunk of SQL is valid on mysql and postgres, but not on oracle.
> > The oracle docs I have seem to claim that it's kosher.  Anyone have a helpful
> > suggestion for how to make oracle happy with this:
> > 
> > SELECT DISTINCT * from Tablename;
> > 
> > Thanks,
> >         Jesse

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

They'll take my private key when they pry it from my cold dead fingers!




More information about the Rt-devel mailing list