rdbhost.blogspot.com

select-into.blogspot.com

SELECT ... INTO: Beyond Little Bobby Tables

http://select-into.blogspot.com/2011/01/little-bobby-tables.html

SELECT . INTO. A lesson a week in PL/pgSQL. As I learn how to do useful things in PL/pgSQL, I will share the lessons with you. Thursday, January 20, 2011. Beyond Little Bobby Tables. The xkcd comic about 'little bobby tables' is a classic, widely known and often quoted:. Xkcd: Exploits of a Mom. The strip title is 'Exploits of a Mom', and the punch-line is 'I hope you've learned to sanitize your database inputs'. However, there are other ways to accomplish the desired safety. Posted by David Keeney.

select-into.blogspot.com

SELECT ... INTO: More elegant forms of returning records.

http://select-into.blogspot.com/2011/01/more-elegant-forms-of-returning-records.html

SELECT . INTO. A lesson a week in PL/pgSQL. As I learn how to do useful things in PL/pgSQL, I will share the lessons with you. Thursday, January 27, 2011. More elegant forms of returning records. Here the record is defined within the function, keeping the parameter list a clean list of inputs. A limitation of this approach is that since the record definition is hidden from the caller, the column list must be provided as part of the retrieving. SELECT . INTO. Line 9 is a. If you define the record type out...

select-into.blogspot.com

SELECT ... INTO: PL/pgSQL dabbling for free

http://select-into.blogspot.com/2010/12/plpgsql-dabbling-for-free.html

SELECT . INTO. A lesson a week in PL/pgSQL. As I learn how to do useful things in PL/pgSQL, I will share the lessons with you. Thursday, December 16, 2010. PL/pgSQL dabbling for free. If you do not have a PostgreSQL server available to dabble with, and you wish to do some learning by experimentation, free database accounts are available at Rdbhost.com. These databases are accessible through a small variety of APIs, but the straightforward way for our purposes is to use the on-site admin tool, RdbAdmin.

select-into.blogspot.com

SELECT ... INTO: A row at a time.

http://select-into.blogspot.com/2010/12/row-row-your.html

SELECT . INTO. A lesson a week in PL/pgSQL. As I learn how to do useful things in PL/pgSQL, I will share the lessons with you. Thursday, December 30, 2010. A row at a time. This week, we will be discussing functions that use exactly one row. Functions can take individual rows as parameters, and can generate individual rows. We will be discussing various syntax forms used for these purposes. But first, an aside:. If this function was created by a role with greater privilege (such as the Super role at an R...

select-into.blogspot.com

SELECT ... INTO: December 2010

http://select-into.blogspot.com/2010_12_01_archive.html

SELECT . INTO. A lesson a week in PL/pgSQL. As I learn how to do useful things in PL/pgSQL, I will share the lessons with you. Thursday, December 30, 2010. A row at a time. This week, we will be discussing functions that use exactly one row. Functions can take individual rows as parameters, and can generate individual rows. We will be discussing various syntax forms used for these purposes. But first, an aside:. If this function was created by a role with greater privilege (such as the Super role at an R...

select-into.blogspot.com

SELECT ... INTO: PostgresOnline: Quick Guide to Writing PLPGSQL

http://select-into.blogspot.com/2010/12/postgresonline-quick-guide-to-writing.html

SELECT . INTO. A lesson a week in PL/pgSQL. As I learn how to do useful things in PL/pgSQL, I will share the lessons with you. Thursday, December 23, 2010. PostgresOnline: Quick Guide to Writing PLPGSQL. Just this morning, I discovered a good short series on writing PL/pgSQL functions. These guides are written as part of the Postgres Online Journal. By Regina Obe and Leo Hsu. Aside from this short series (from back in 2008, but still very relevant), there is a lot of interesting stuff there.

select-into.blogspot.com

SELECT ... INTO: Returning a few rows

http://select-into.blogspot.com/2011/01/returning-few-rows.html

SELECT . INTO. A lesson a week in PL/pgSQL. As I learn how to do useful things in PL/pgSQL, I will share the lessons with you. Thursday, January 13, 2011. Returning a few rows. This week, we will look at returning a few rows from a function. Database programming typically involves getting sets of records, so this output ability is natural to look for, in a programming language that runs internally to a database engine. Lines 6 through 8 define a loop, which iterates over values from 0 to the count limit&...

select-into.blogspot.com

SELECT ... INTO: What's next..

http://select-into.blogspot.com/2011/01/whats-next.html

SELECT . INTO. A lesson a week in PL/pgSQL. As I learn how to do useful things in PL/pgSQL, I will share the lessons with you. Thursday, January 6, 2011. PL/pgSQL is basically a language for writing functions. You cannot just inline a PL/pgSQL statement into a query wherever. You define functions, and then use those functions to enhance queries, or to perform automated actions as triggers. How to structure a function; what are the minimum set of parts. How to return a simple calculated value. Well, in 9&...

select-into.blogspot.com

SELECT ... INTO: January 2011

http://select-into.blogspot.com/2011_01_01_archive.html

SELECT . INTO. A lesson a week in PL/pgSQL. As I learn how to do useful things in PL/pgSQL, I will share the lessons with you. Thursday, January 27, 2011. More elegant forms of returning records. Here the record is defined within the function, keeping the parameter list a clean list of inputs. A limitation of this approach is that since the record definition is hidden from the caller, the column list must be provided as part of the retrieving. SELECT . INTO. Line 9 is a. If you define the record type out...