Hello group,
I 've written the following function:
CREATE OR REPLACE FUNCTION public.getstadtlandflussentrybyid (integer) RETURNS SETOF public.ty_stadtlandflussentry AS'DECLARE objReturn ty_stadtlandflussentry;
DECLARE iid integer;BEGIN iid := $1; for objReturn IN SELECT ste_id, ste_type,
On Sep 12, 2005, at 8:14 AM, Moritz Bayer wrote:
I get the following error:
ERROR: missing .. at end of SQL expression
it looks like your for loop is being interpreted as the integer
variant, e.g. for i in 1..10 loop
CREATE TYPE public.ty_stadtlandflussentry AS (
DECLARE objReturn
Moritz Bayer [EMAIL PROTECTED] writes:
I get the following error:
ERROR: missing .. at end of SQL expression
I haven't figured out what this message wants to tell me and why it is
thrown at all.
I think it's telling you that you are using a 7.3 or older server.
Try 7.4 or later --- plpgsql
Hi all. I have troubles trying to achieve this assignment:
suppose the
type mycolumn as (field1, varchar, field2 varchar)
and
field_name = ''field1''
and returnValue declared as mycolumn
...
can i say returnValue.$field_name = ''ok''?
There is a way to achieve this piece of code?
Thanks a
On Mon, Sep 12, 2005 at 12:21:22PM -0300, [EMAIL PROTECTED] wrote:
suppose the
type mycolumn as (field1, varchar, field2 varchar)
and
field_name = ''field1''
and returnValue declared as mycolumn
...
can i say returnValue.$field_name = ''ok''?
To achieve this in PL/pgSQL you'll need
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thank you for an excellent answer. I think I will have to study your
code for a while. But is it such a bad idea to have a separate column
for the primary key here? I see that there are two schools on this,
with diametrically opposed views.
Hi,
let's say one has an user defined data type
CREATE TYPE foobar_t AS ( va varchar(25), vb varchar(4), vc varchar(20), ia
integer, ib integer );
and a stored procedure in plgpsql (stripped and sample only):
CREATE OR REPLACE FUNCTION foobar(int, foobar_t, int, varchar) RETURNS
On Tue, Aug 30, 2005 at 03:38:52PM +0700, Ricky Sutanto wrote:
I use Apache Web Server and PostgreSQL 7.3 to collect data everyday. Now it
has been 5 month since I install that server.
I wonder why now my web very slow to retrieve and display data?
When I check the memory, I found that
Silke Trissl wrote:
As far I could read from the documentation - this should be possible.
But my question is, is there a kind of index on the array.
If your needs are a bit more modest (say, a few thousands instead of
billions) the stuff in contrib/intarray works well; and if you
needed
If you need to know the age to the nearest day on the present day
I think you can use something like:
select date_trunc('day',age(now(),dateofbirth)) from people
gives:
3 years 2 mons 12 days
My questions is, is there any way to convert that figure into an age
expressed as a number days only?
This will give you the no of days.select current_date - dateofbirth::date from people;
On 9/9/05, Mark A. Strivens [EMAIL PROTECTED] wrote:
If you need to know the age to the nearest day on the present dayI think you can use something like:select date_trunc('day',age(now(),dateofbirth)) from
On Sep 10, 2005, at 1:04 AM, Mark A. Strivens wrote:
select date_trunc('day',age(now(),dateofbirth)) from people
My questions is, is there any way to convert that figure into an age
expressed as a number days only?
Try
select current_date - dateofbirth from people;
Michael Glaesemann
On Mon, Sep 12, 2005 at 11:01:08AM -0700, Wei wrote:
I followed the doc and tried select CAST(1126547334 AS timestamp) and
I only got an error response that says: ERROR: cannot cast type
integer to timestamp without time zone.
What documentation suggested casting an integer to a timestamp?
13 matches
Mail list logo
