Skip site navigation (1) Skip section navigation (2)

Is there anyway to do this?

From: Wei Weng <wweng(at)kencast(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Is there anyway to do this?
Date: 2002-10-18 16:45:56
Message-ID: 1034959557.27181.3.camel@Monet (view raw or flat)
Thread:
Lists: pgsql-sql
I have a table 

               Table "Users"
  Column   |          Type          | Modifiers 
-----------+------------------------+-----------
 userid    | character varying(40)  | not null
 username  | character varying(64)  | 

I want to get all the distinct first character of all usernames. And do
it in a way that is the most portable to MS SQL server.

Is there anyway?

Thanks

-- 
Wei Weng
Network Software Engineer
KenCast Inc.



Responses

pgsql-sql by date

Next:From: Martin CrundallDate: 2002-10-18 16:59:10
Subject: Re: TRIGGERed INSERTS
Previous:From: jmDate: 2002-10-18 16:18:27
Subject: isAutoIncrement and Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group