From: Rehan Saleem [mailto:pk_re...@yahoo.com]
Sent: Sunday, February 26, 2012 1:50 PM
To: pgsql-sql@postgresql.org
Subject: SQL View to PostgreSQL View
Hi ,
I am trying to convert sql view to postgresql view but i am getting the
following error i dont know how to handle dbo. in postgresql and
Took some time until I could try out this...
But as soon I want to create the fcuntion based index it tells me:
Error : ERROR: functions in index expression must be marked IMMUTABLE
Deleteing the sort function and recreating with the IMMUTABLE attribute gives
the same error..
Here the
Tirsdag 28. februar 2012 12.56.46 skrev Rehan Saleem :
> hi ,
> whats wrong with this function , i am getting syntax error which is syntax
> error at or near "+=" LINE 13: set sql += ' bpoverlap, centredistance
You can't concatenate that way in plpgsql. Instead of "set sql +=" try with
just "||
hi ,
whats wrong with this function , i am getting syntax error which is syntax
error at or near "+="
LINE 13: set sql += ' bpoverlap, centredistance from vwchrcomparesit...
^
how this problem can be solved.
thanks
CREATE OR REPLACE FUNCTION getsitesbytfid(user_datadetailid in
hi ,
whats wrong with this function , i am getting syntax error which is syntax
error at or near "+="
LINE 13: set sql += ' bpoverlap, centredistance from vwchrcomparesit...
^
how this problem can be solved.
thanks
CREATE OR REPLACE FUNCTION getsitesbytfid(user_datadetailid in
Hi Rehan,
Whilst I'm not sure what you exactly mean with ', while this is
working perfectly fine in sql,..',
it's kind of odd that you get result when you execute the sql.
I'd suggest looking at your search_path (show search_path), which
normally resolves to 'user', 'public';
If you do h
On Tue, Feb 28, 2012 at 9:50 AM, Rehan Saleem wrote:
> hi ,
> how can i convert this sql store procedure to postgresql function , i shall
> be very thankful to you, as i am new to postgresql and i dont know how to
> handle this kind of store procedure in postgresql
Most people handle this with u
hi ,
how can i convert this sql store procedure to postgresql function , i shall be
very thankful to you, as i am new to postgresql and i dont know how to handle
this kind of store procedure in postgresql
thanks
ALTERPROCEDURE [dbo].[sp_GetUserByID]
@UserId varchar(50),
@KBId varch
