473,699 Members | 2,848 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Stored functions books

8 New Member
I'm looking for a good manual on stored functions in postgres. Other then using the postgres web site, I haven't really found something I can keep on my desk for a good reference. My current book "PostgresSq l Developer's Handbook" should have stayed in the forest. Thanks for your help.
Jul 26 '07 #1
0 1405

Sign in to post your reply or Sign up for a free account.

Similar topics

15
6007
by: Jarrod Morrison | last post by:
Hi All Im generally a vb programmer and am used to referencing multiple records returned from a query performed on an sql database and im trying to move some functions of my software into sql stored procedures. So far ive been able to move the functions relatively easily but im unsure about how to output multiple values from an sql stored procedure. By this i mean for example one of the stored procedures may take your username and return...
0
6698
by: Nashat Wanly | last post by:
HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET View products that this article applies to. This article was previously published under Q310070 For a Microsoft Visual Basic .NET version of this article, see 308049. For a Microsoft Visual C++ .NET version of this article, see 310071. For a Microsoft Visual J# .NET version of this article, see 320627. This article refers to the following Microsoft .NET...
3
1318
by: Michael Freiermuth | last post by:
Hello everybody, I have a file with several asp functions where some depend on others. Some of the functions I will need to transform a string value. How can I include these functions in a stored procedure? (in Sql Server 2000) Do I have to add all the functions as userdefined functions? Or is possible to reference the external file like include files in
9
6437
by: Wolfgang Kreuzer | last post by:
Try hard to become familiar with T-SQL. Can anybodey tell me the best way to deal with set's provided by a stored procedure. Til yesterday I thougt trapping set in temp table using INSERT EXEC is a way out of this, but then I struggeled with nested INSERT EXEC's. What are all the system proc's good for if the results cannot be evaluated? The approach of modular programming is to have code doing similar things in one place.
15
22882
by: Steve | last post by:
I am trying to develop a stored procedure for an existing application that has data stored in numerous tables, each with the same set of columns. The main columns are Time and Value. There are literally hundreds of these tables that are storing values at one minute intervals. I need to calculate the value at the end of the current hour for any table. I am a little new to SQL Server, but I have some experience with other RDBMS. I get an...
1
1355
by: Pumkin | last post by:
Hey guys, I'm trying to get the column names from a table to which I'm connected through OBDC. I don't want to use linked server. I get my data with Openrowset. I found the SQLDescribeCol and SQLColumns ODBC functions. Can anybody tell me how to use those functions in a SQL Server stored procedure?
1
2403
by: Daniel Manes | last post by:
I've been trying to copy tables from a linked server to a SQL Server Express database. Express seems to have no direct/automatic way to do it, so I've been looking into doing this by hand (i.e., with a T-SQL procedure). I've discovered some system stored procedures that seem relevant (like sp_tables_ex and sp_columns_ex). But they're procedures, not table-valued functions, so I'm not sure if I can actually do anything with the data they...
2
19897
by: traceable1 | last post by:
In SQL 2005 (we use Enterprise 64-bit SP2), the users cannot see the text of the stored procedures, functions, etc. This is a production database, so I cannot give them rights to modify them, but they need to be able to see what the procs are doing. I didn't have this problem in 2000 - how can I adjust the privileges to allow them to view the contents of the Programmability objects? thanks for any insight!!
2
2966
by: Chris | last post by:
I have a database column that stores a comma delimited list of foreign keys. Would someone show me how to do a join using the values from a list stored within a record? For example, a record in tbl_cds.genre_id might have a value of "2, 5, 6" corresponding to genre_ids 2 , 5 and 6. I want to join tbl_cds.genre_id to tbl_genre.genre_id using the values in that data field. It seems I need a loop like this:
1
3870
by: rshivaraman | last post by:
Hi All : A couple of tables have been identified to be deleted. My job is to find if it is at all used. On searching the web, i found a proc to search for a string within all databases in a server. using system sproc : sp_msforeachdb it searches for a string in views, sprocs, functions, check constraints, defaults, foreign key,
0
8704
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8623
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9054
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8936
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6544
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5879
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4637
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3071
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2015
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.