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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

  From Date Subject
Next Message Martin Crundall 2002-10-18 16:59:10 Re: TRIGGERed INSERTS
Previous Message jm 2002-10-18 16:18:27 isAutoIncrement and Postgres