On 09/28/2010 10:36 PM, Tarlika Elisabeth Schmitz wrote:
On Tue, 28 Sep 2010 11:34:31 +0100
"Oliveiros d'Azevedo Cristina" wrote:
- Original Message -
From: "Tarlika Elisabeth Schmitz"
To:
Sent: Monday, September 27, 2010 5:54 PM
Subject: Re: [SQL] identifying duplicates in table with
The only chance I see is to combine the information about the
localization with the address pattern.
regards
Andreas
On 09/23/2010 09:12 AM, negora wrote:
I guess that it's impossible to look for a solution which works on
every existing case, specially if you're handling addresses from
Hello,
is there any equivalent for ORACLEs decode() in pl/pgsql ?
regards,
-Andreas
--
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
ed correctly but the ranking is a mess. I
recongnized that the select seems to follow primarily the internal table
order. Is there any way to solve this nicely. Hints and solutions are
appreciated.
Thanks in advance
-Andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Serv
rom tipp_team_members where member_team_id=2 and
member_user_id=27;
WARNING: Error occurred while executing PL/pgSQL function
update_team_member_count
WARNING: line 13 at if
ERROR: Attribute "delete" not found
tippspiel2003=#
What am I making wrong ?
best regards
-Andreas Schmitz
--
An
then DROP table kokot ..
>
> 3) and then again CREATE table
>
> CREATE TABLE "kokot" (
> "kokot" SERIAL );
>
> PostgreSQL return this error
>
> PostgreSQL said: ERROR: Relation 'kokot_kokot_seq' already exists
> Your query:
> CREATE TAB
". but I am not sure if
this will display your needs. Do you really need the data like "ORD0244,
ORD0245..." ? Then you should use an array or set datatype. They are
normally not nice to handel.
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Te
