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 strongm 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: nhjyjetsfan
- Order by date
-
Example of a Postgre Stored Procedure
Stored Procedures seem to stump almost everyone trying to migrate from M$SQL to Postgre. In all actuality it is realitively simple. I will start by creating a simple Employee table. Then i will create a sequence to create autonumbers for my EmployeeID column (Same as M$SQL IDENTITY(1,1)... -
Stored Procedures in Postgre
ooops! there is a type near the end where it states: SELECT fn_addemp('add','your','info','like,'this');[/b] sorry it is 2:47 AM and i am quite tired... [COLOR=green]GO JETS!!!- nhjyjetsfan
- Post #2
- Forum: PostgreSQL Inc.: PostgreSQL
-
Stored Procedures in Postgre
Stored Procedures seem to stump almost everyone trying to migrate from M$SQL to Postgre. In all actuality it is realitively simple. I will start by creating a simple Employee table. Then i will create a sequence to create autonumbers for my EmployeeID column (Same as M$SQL IDENTITY(1,1)...- nhjyjetsfan
- Thread
- Replies: 3
- Forum: PostgreSQL Inc.: PostgreSQL
-
SELECT Statement
Thanks leland however that was not the issue... the issue was specific to vb.net syntax... By the way I have a little tid bit for those who constantly ask: What about stored procedures in postgre? YES IT IS POSSIBLE>>> I am going to post a simple stored procdure HOW TO this weekend...- nhjyjetsfan
- Post #4
- Forum: PostgreSQL Inc.: PostgreSQL
-
SELECT Statement
Disregard MS vb.net issue Thanks- nhjyjetsfan
- Post #2
- Forum: PostgreSQL Inc.: PostgreSQL
-
SELECT Statement
I am having a nightmare trying to retrieve data using a select statement. I can insert into my table but cannot retrieve via SELECT. I am stumped. Using SELECT * FROM tblemployees returns nothing If I use pgadmin i can retrieve my data with the exact SELECT statement above. Discouraged...- nhjyjetsfan
- Thread
- Replies: 3
- Forum: PostgreSQL Inc.: PostgreSQL
