quot; UNIQUE ("name");
----
select * from "test"('second')
will return one row with data
but
select * from "test"('secon')
will raise an ERROR
and
select * from "test2"('secon')
will return empty set.
I think that is more conveniently that when no data is fetched
such function returns instance of composite type with nulls.
In case of function returning record type we also "know" schema of
the last select.
Of course it is possible to use plpgsql function and select into
but sql functions is smaller and don't require handler.
--
Best regards,
Ivan mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hello Tom,
Tuesday, September 21, 2004, 6:17:37 PM, you wrote:
TL> Ivan <[EMAIL PROTECTED]> writes:
>> Suppose we have sql function which returns composite type.
>> When such function's last select statement doesn't return any row
>> error occurs -
>> E
ple1
pg_dump.exe: [archiver (db)] connection to database "example1" failed: FATAL: user
"'postgres'" doe
s not exist
pg_dumpall.EXE: pg_dump failed on database "example1", exiting
--
Best regards,
Ivan mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hello Nicola,
Monday, November 22, 2004, 9:00:30 PM, you wrote:
NP> I've been experiencing data corruption/loss in Postgresql 7.4.2.
Try to recompile (create or replace) your stored procedure
after you alter the table
Hope this help...
--
Best regard
_type AS
$BODY$
select "Id"::int4, "Data"::test_domain
from (
select 1 as "Id", 'string1' as "Data"
union all
select 2 as "Id", 'string2' as "Data"
) as q1;
$BODY$
LANGUAGE 'sql' VOLATILE;
CT* 1" (cost=0.00..0.02 rows=1 width=0)
-> Result (cost=0.00..0.01 rows=1 width=0)
-> Subquery Scan "*SELECT* 2" (cost=0.00..0.02 rows=1 width=0)
-> Result (cost=0.00..0.01 rows=1 width=0)
select 1 as "Id", &
It's very annoy, so please fix if it's not very hard.
Thank you!
--
Best regards,
Ivan mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
Hello,
Thursday, October 27, 2005, 6:34:36 PM, you wrote:
TL> Ivan <[EMAIL PROTECTED]> writes:
>> When I create a function in sql or plpgsql languages,
>> their body text is stored in the database files with
>> 0D 0A line ends (I checked it in a hex editor).
>&g
Hello,
TL> Ivan <[EMAIL PROTECTED]> writes:
>> When I create a function in sql or plpgsql languages,
>> their body text is stored in the database files with
>> 0D 0A line ends (I checked it in a hex editor).
>> If I create plain backup using pg_dump
>> it
d you please add -f option to pg_dumpall,
because it's very inconvenient to replace these
character sequences in hex editor all the time.
Thank you for support!
--
Best regards,
Ivan mailto:[EMAIL PROTECTED]
---(end of
Hello Alvaro,
Thursday, November 3, 2005, 3:28:41 PM, you wrote:
AH> Ivan wrote:
AH> Hi,
>> Perhaps you missed my previous message.
>> pg_dumpall has not -f command line option
>> to specify output file - it always send output
>> to standart output. But there is
I use a DIGITAL ALPHA DEC2000 AXP500 with 128MB of RAM, architecture EV4
150MHz processor. I installed a Debian potato (2.2) and got problems
during installation, postmaster not starting.
After a mail exchange with postgres Debian mantainer, got sources of
postgresql version 7.0.3 (debian patched)
Severity: Devastating
Short description:
Simple SELECT query with simple REGEXP comparison with simple
ORDER
and WITHOUT JOINS CRASHES BACKEND (seems to die in an infinite loop that
consumes CPU and uses the hard disk).
Long description:
The query:
SELECT t.* FROM t
The following bug has been logged online:
Bug reference: 2726
Logged by: Ivan Volf
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: linux
Description:reindex database failed if number is in database name
Details:
drin=# reindex database
" solution?
Helmar, thank you very match.
Regards, Ivan.
**
* *From*: *Helmar Spangenberg mailto:[EMAIL PROTECTED]>>*
* *To*: *pgsql-bugs ( at ) postgresql ( dot ) org
<mailto:[EMAIL PROTECTED]>*
* *Subject*: *Bug concerning regular expressions and UTF-8*
* Date
|
Index: forum_data_pkey
We can't solve this problem.
Thank you.
Anton Ruhl, Ivan Dolinin (Russia, Tomsk)
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hi,
I'm not sure if you know this problem.
Create an empty function with 26 parameters:
create function test (INTEGER,TEXT,TEXT,TEXT,CHAR(16),CHAR(11),
BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,
BOOLEAN,BOOLEAN,BOOLEAN,CHAR(2),TEXT,TEXT,TEXT,TEXT,
CHAR(5),TEXT,TEXT,TEXT,TEXT,TEXT )
returns i
Pack 2 Build 2600
Thank you.
--
Best regards,
Ivan mailto:[EMAIL PROTECTED]--
-- PostgreSQL database dump
--
SET client_encoding = 'WIN';
SET check_function_bodies = false;
SET SESSION AUTHORIZATION 'root';
--
-- Name: public; Type: SCHEMA; Schema:
The following bug has been logged online:
Bug reference: 1380
Logged by: Ivan Chumak
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: windows 2000
Description:dont reading messages in russian languages
Details:
i talking about messages
The following bug has been logged online:
Bug reference: 1520
Logged by: Ivan Chumak
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Windows XP SP2
Description:messages in Russian is made wrong
Details:
The derivation (conclusion) of
The following bug has been logged on the website:
Bug reference: 8389
Logged by: Ivan Pliouchtchai
Email address: ivan@solidit.cl
PostgreSQL version: 9.2.4
Operating system: Windows 7
Description:
PRECONDITION:
When having a table with the next columns:
content
docs_requeridos values
(243,5,15,123456,'01/11/2004','ivan',1);
the date format that we use is DD/MM/ but whet we execute a select
command we get this information:
id |status|id2|serie |date_exe
Tom you right!!
We only set PGDATESTYLE on root env and then restart the httpd
thanks
Tom Lane wrote:
"Ivan E. Rivera Uria" <[EMAIL PROTECTED]> writes:
the date format that we use is DD/MM/ but whet we execute a select
command we get this information:
Sounds to me like
Title: finger print (minutias)
Hi.
I would like to know if it posible record a minutias code in Postgre SQL, it is a binary data
Ivan E. Rivera Uria
Company: BNC MEXICO
Phone Number: +(52)-55-5241-0670
Fax Number: +(52)-55-5241-0680
Direct Number:+(52)-55-5241-0688
Company Mail
24 matches
Mail list logo
