X-Original-To: pgsql-es-ayuda-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 15A0A52B58 for ; Mon, 25 Jul 2005 19:40:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13453-07 for ; Mon, 25 Jul 2005 22:40:05 +0000 (GMT) Received: from n6.gigared.com (smtp1.gigared.com [200.68.216.6]) by svr1.postgresql.org (Postfix) with ESMTP id DEAF652B0F for ; Mon, 25 Jul 2005 19:40:02 -0300 (ADT) Received: from [204.246.232.213] (unknown [204.246.232.213]) by n6.gigared.com (Postfix) with ESMTP id 1CF5CF2CC; Mon, 25 Jul 2005 19:39:40 -0300 (GMT) From: =?iso-8859-1?q?Mart=EDn_Marqu=E9s?= To: pgsql-es-ayuda@postgresql.org Subject: Re: =?iso-8859-1?q?=BFComo_evitar_el?= "case sensitive"? Date: Mon, 25 Jul 2005 19:41:22 -0300 User-Agent: KMail/1.7.1 Cc: Morena =?iso-8859-1?q?Gonz=E1lez?= References: <20050725205513.76507.qmail@web30814.mail.mud.yahoo.com> <20050725211526.GA32731@alvh.no-ip.org> <000e01c59163$485de4f0$7601a8c0@auditoria.local> In-Reply-To: <000e01c59163$485de4f0$7601a8c0@auditoria.local> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200507251941.22964.martin@bugs.unl.edu.ar> X-Gigared-MailScanner-Information: MailScanner: Found to be clean X-MailScanner-From: martin@bugs.unl.edu.ar X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.898 tagged_above=0 required=5 tests=AWL, INVALID_TZ_GMT X-Spam-Level: X-Archive-Number: 200507/553 X-Sequence-Number: 9064 El Lun 25 Jul 2005 18:53, Morena Gonz=E1lez escribi=F3: > Hola. >=20 > Se puede de alguna manera configurar postgresql para que no sea case=20 sensitive?=20 > Y no me refiero a utilizar ILIKE en las consultas sino a configurar de=20 alguna manera que cuando ejecute cualquier cosa no me distinga entre=20 may=FAsculas y min=FAsculas? Que yo sepa no se puede. Eso seria muy DOS. ;-) =2D-=20 select 'mmarques' || '@' || 'unl.edu.ar' AS email; =2D-------------------------------------------------------- Mart=EDn Marqu=E9s | Programador, DBA Centro de Telem=E1tica | Administrador Universidad Nacional del Litoral =2D--------------------------------------------------------