Re: How to merge several attributes and Delete an attribute - Mailing list pgsql-sql

From Annie Bai
Subject Re: How to merge several attributes and Delete an attribute
Date
Msg-id F187qsh1lBLMasiZAPG0000a858@hotmail.com
Whole thread Raw
In response to How to merge several attributes and Delete an attribute  ("Yan Bai" <annie_job@hotmail.com>)
Responses Re: How to merge several attributes and Delete an
List pgsql-sql
Well, I am not familiar with functions, Do they have better performance than 
the plain query as the following?

select * from table where Firstname like 'blah' or middlename like 
'blah'....

Thank you
Annie

>From: Vladimir Terziev <vladimirt@rila.bg>
>To: "Yan Bai" <annie_job@hotmail.com>
>Subject: Re: [SQL] How to merge several attributes and Delete an attribute
>Date: Thu, 31 Jan 2002 10:21:31 +0200
>
>    Hi,
>    I sugest you to use 'textcat' function. Something like this:
>        select textcat(textcat(textcat(textcat($1, " "), $2), " "), $3)
>    ' language 'SQL';
>
>    select * from your_table where textcat(textcat(textcat(textcat(FirstName, 
>' '), MiddleName), ' '), LastName) like '%somename%';
>
>    Good luck!
>
>        Vladimir
>
>
>On Thu, 31 Jan 2002 07:34:40 +0000
>"Yan Bai" <annie_job@hotmail.com> wrote:
>
> > Hello all,
> >
> > My initial table has 3 attributes: FirstName, MiddleName and LastName. 
>Now I
> > want to merge them into one, then I could make a search action using 
>LIKE
> > more easily.
> > what should i do for that?
> >
> > Also, I want to know how to delete one attribute from a table.
> >
> > Thanks a lot,
> >
> > Annie
> >
> > _________________________________________________________________
> > MSN Photos is the easiest way to share and print your photos:
> > http://photos.msn.com/support/worldwide.aspx
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly


_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Regression tests failed on 7.2rc2
Next
From: "Josh Berkus"
Date:
Subject: Re: How to merge several attributes and Delete an