I installed the hstore module (http://www.postgresql.org/docs/current/
static/hstore.html) because I have a situation where I prefer to use
hstore instead of XML.
Everything works great, but I saw that after installing the module I
actually have two new datatypes: hstore and ghstore. The last one
I can't answer your question but I think you may have a serious
database design issue at hand.
Why not try to accomplish your goals in a simpler way?
Regards,
Ivan Pavlov
On Dec 15, 12:49 pm, ket...@ketema.net (Ketema Harris) wrote:
> I am interested in finding out the pros, cons, pit
Neiter LOG ERRORS nor REJECT LIMIT are implemented in PostgreSQL,
though I agree they may be useful. Both can be simulated with a custom
stored procedure which loops over a cursor and updates row-by-row,
trapping errors along the way. This will, of course, be slower.
regards,
Ivan Pavlov
On
roup' || i INTO value
will work in a loop. Didn't try it though.
regards,
Ivan Pavlov
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
If you need them one by one why fetch them into tmprec? Take a look at
the docs for FETCH:
http://www.postgresql.org/docs/8.3/static/sql-fetch.html
especially the FETCH ABSOLUTE...
regards,
Ivan Pavlov
On Dec 16, 3:37 pm, aesthete2...@gmail.com ("Иван Марков") wrote:
> Hello.
I have a store procedure which returns a record; the query is defined as:
select * from spec_proc.view_empl_1('bg',2) AS (f1 varchar, f2 varchar,
f3 date, f4 varchar, f5 varchar,f6 varchar,f7 varchar, f8 varchar, f9
int, f10 varchar, f11 varchar, f12 varchar, f13 int, f14 varchar, f15
date, f16 da
re
proc. My guess is that this caused the error I mentioned.
Thanks once again for your help
Ivan Pavlov
Michael Fuhr wrote:
> On Mon, Oct 10, 2005 at 06:43:25PM +0300, Ivan Pavlov wrote:
>
>>I have a store procedure which returns a record; the query is defined as:
>>
>>se
gt; To participate in the translation effort, please follow the instructions set
> out on that page, or contact me directly if you have further questions.
>
Is there any particular reason why there is no translation in Bulgarian?
If it's only the lack of contributors, you can count m
