Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: thedumbkid
- Content: Threads
- Order by date
-
anybody ever tried to use backward slash???
anybody ever tried to do: INSERT INTO mytable (column1) VALUES ('\'); that doesn't seem to work but INSERT INTO mytable (column1) VALUES ('\\'); works... why is that???- thedumbkid
- Thread
- Replies: 5
- Forum: PostgreSQL Inc.: PostgreSQL
-
Question about dynamic query
I have another question :) It's about dynamic query... Is it possible to use a dynamic query in pl/pgsql function to update a variable? I am trying to do something like the following: create function myfunction(varchar) returns int4 as ' declare v_table_name alias for $1; v_num int4...- thedumbkid
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
-
question about returns "set"
Is returns "set" the same as returning a table??? by that I mean, if I have a function that returns "set" can I do the following? create function myfunction() returns "set" as ' begin return [some SELECT statement here]; end;' language 'plpgsql'; if so, can...- thedumbkid
- Thread
- Replies: 4
- Forum: PostgreSQL Inc.: PostgreSQL
-
default value for parameters
Hi people, I am doing database migration from MS SQL Server to PostgreSQL. I need to know whether parameters can have default values? In ms sql server, you can assign default values to your parameters. This feature allows you to call the stored procedure without giving parameters that have...- thedumbkid
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
