Re: Iki alani birlestirmede arama

From: "Adnan DURSUN" <a_dursun(at)hotmail(dot)com>
To: "absal" <crazykingtr(at)yahoo(dot)com>, <pgsql-tr-genel(at)postgresql(dot)org>
Subject: Re: Iki alani birlestirmede arama
Date: 2006-06-13 10:30:43
Message-ID: BAY106-DAV80AEE3F5A93486CEECB59FA8C0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-tr-genel

Merhaba,

Yazdiginiz sekilde bir sql sorgu çalismayacaktir. Bunu 2 sekilde
yapabilirsiniz ;

1. select * from (Select cast(adi || ' ' || soyadi as varchar) as isim from
tablombenim) x Where x.isim like 'Ha%'
2. select * from tablombenim where adi||soyadi like 'Ha%'

Iyi çalismalar

Adnan DURSUN
ASRIN Bilisim Ltd.
----- Original Message -----
From: "absal" <crazykingtr(at)yahoo(dot)com>
To: <pgsql-tr-genel(at)postgresql(dot)org>
Sent: Tuesday, June 13, 2006 10:36 AM
Subject: [pgsql-tr-genel] Iki alani birlestirmede arama

iki alani sql de birlestirip bir degere atadigimda bu deger de
arama yapmam mümkünmüdür ?
Asagidaki komut nasil çalisir.Simdidenn tsk.

Select cast(adi || ' ' || soyadi as varchar) as isim from tablombenim
Where isim like 'Ha%'

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

In response to

Browse pgsql-tr-genel by date

  From Date Subject
Next Message Bruce Momjian 2006-06-14 21:00:13 Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Previous Message absal 2006-06-13 07:36:09 Iki alani birlestirmede arama