Hello
In my PostgreSQL database i have records inserted in Uppercase.
For example: VIA SENATO
What i want is to change them to Via Senato. Ofcourse i'm looking for a
automatico way. I wrote this code update registro1 set pa_indirizzo =
upper(substr(pa_indirizzo, 1, 1))
Replace by ||
Shavonne Marietta Wijesinghe [EMAIL PROTECTED] 2007-02-19 16:22
Hello
In my PostgreSQL database i have records inserted in Uppercase.
For example: VIA SENATO
What i want is to change them to Via Senato. Ofcourse i'm looking for a
automatico way. I wrote this code update
On Mon, Feb 19, 2007 at 04:22:06PM +0100, Shavonne Marietta Wijesinghe wrote:
Hello
In my PostgreSQL database i have records inserted in Uppercase.
For example: VIA SENATO
What i want is to change them to Via Senato.
Have a look at the initcap() function.
A
--
Andrew Sullivan |
Hey thanks Bart. it worked ;)
but sadly what it does is changes VIA SENATO in to Via senato but what i
need is Via Senato
Anyoneee??
Shavonne Wijesinghe
- Original Message -
From: Bart Degryse
To: pgsql-sql@postgresql.org
Sent: Monday, February 19, 2007 4:25 PM
Of course it does. That's what you ask your query to do. You only used the
wrong operator for string concatenation, which is why it didn't seem to work.
But your query will not do this for each word in a field. For that you need a
function or regular expressions. I suggest you try
select
Shavonne Marietta Wijesinghe wrote:
Hey thanks Bart. it worked ;)
but sadly what it does is changes VIA SENATO in to Via senato but what i
need is Via Senato
Anyoneee??
initcap() does what you want.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
Robert is right of course. You can eg use a trigger to do that...
I haven't tested, but I guess something like this would do what you want
whenever you insert records in your table
CREATE OR REPLACE FUNCTION public.func_change_case () RETURNS trigger AS
$body$
BEGIN
NEW.pa_indirizzo :=
Hi,
I have a query regarding an SQL statement I'm trying to execute. I
have the following table:
sequence
-+
AK
AKCMK
CMKA
I execute the following statement (Cartesian product):
SELECT p1.sequence as sequence1, p2.sequence as sequence2
FROM potential_pairs p1, potential_pairs p2
On Mon, 2007-02-19 at 10:58, Salman Tahir wrote:
Hi,
I have a query regarding an SQL statement I'm trying to execute. I
have the following table:
sequence
-+
AK
AKCMK
CMKA
I execute the following statement (Cartesian product):
SELECT p1.sequence as sequence1,
On Mon, 2007-02-19 at 10:58, Salman Tahir wrote:
Hi,
I have a query regarding an SQL statement I'm trying to execute. I
have the following table:
sequence
-+
AK
AKCMK
CMKA
I execute the following statement (Cartesian product):
SELECT p1.sequence as sequence1,
Hi, Salman
Maybe this isn't so much elegant, but works:
SELECT p1.sequence as sequence1, p2.sequence as sequence2
FROM potential_pairs p1, potential_pairs p2
WHERE p1.sequence = p2.sequence
Hope this helps
Salman Tahir wrote:
Hi,
I have a query regarding an SQL statement I'm trying to
Hi all,
Strange one - I have a nightly export / import routine that exports from one
database and imports to another. Has been working fine for several months,
but last night it died on a unique constraint.
To cut out all the details, the code that is causing the problem:
SELECT
Phillip Smith [EMAIL PROTECTED] writes:
To cut out all the details, the code that is causing the problem:
SELECT DISTINCT ON (ean)
code,
CASE WHEN ean IS NULL OR valid_barcode(ean) = false THEN
null ELSE ean END AS ean
FROMTMPTABLE
Removing the CASE statement all together:
SELECT DISTINCT ON (ean)
ean,
count(*)
FROMTMPTABLE
WHERE code NOT IN (SELECT code FROM stock_deleted)
ANDean IS NOT NULL
GROUP BY ean
Still gives me:
3246576919422 2
-Original Message-
From: Tom Lane
Στις Παρασκευή 16 Φεβρουάριος 2007 20:35, ο/η chrisj έγραψε:
I am quite sure the [2] is not discarded, easy enough to test but I don't
have access to PG at the moment.
Well it should, since
dynacom=# SELECT
(CAST( '{{meeting,lunch},{training,presentation}}' as text[][]))[1:1];
text
15 matches
Mail list logo