Posted by strawberry on 05/31/06 17:26

Save yourself the headache and format your tables properly

Mr.Mime wrote:
> Hi to all.
> Excuse my bad english but I have a problem with a query.
>
> I have a table with a colum with datas formatted like this:
> name//surname
>
> For example:
>
> ID | INFO
> 1 | George//Bush
> 2 | Silvio//Berlusconi
>
> What I need is a SELECT with an order by the surname. In the example it
> must return
> 2 and than 1 because Berlusconi is lower than Bush.
>
> I think a regular expression will be fit for this task but I don't know
> how to use it.
> I'm using PostGre SQL with allow subSelection.
>
> Thanks to all for any help.

[Back to original message]