Firebird 2.0
PSQL Reference
Manual

SELECT INTO STATEMENT

Pupose

Use the SELECT INTO statement to retrieve a single row from a table. The PSQL select statement is identical to the SQL select statement followed by an INTO clause and a semicolon.

Syntax

<psql_select_stmt> ::=
   <select_stmt> INTO <var_list> ;

<var_list> ::=
     <variable_name>
   | <variable_name> , <var_list>

<variable_name> ::=   <identifier>


Element
Description
select_stmt

A SQL insert statement as defined in the SQL Reference manual.

variable_name

The name of a local variable of the enclosing body or of a parameter of the enclosing procedure definition.

Semantics

See the SQL Reference Manual for a description of the select statement.

The select statement must return exactly one row. If it returns zero or more than one row, a run-time error occurs.

Examples

The below is an example of a valid INSERT statement in PSQL:

   SELECT COUNT(*) FROM rdb$relations INTO :table_count


See also

DELETE, UPDATE and INSERT


previous page goto index next page

Legal information


User comments:


Contributed by CAhswhJktFMtQKu on 1 June 2008 09:46 AM

doors.txt;10;15

Contributed by unordained on 17 February 2009 05:27 PM

This page seems wrong to me:

- If the select returns more than one row, sql message -811 (engine code 335544652) is raised.
- If the select returns one row, the variables are updated appropriately.
- If the select returns zero rows, the variables are left as-is. No exception is thrown. SQL Code 100 (no data found) does not seem to show up on empty selects. (Neither of this form, nor of the \"for select ... into ... do\" form.)

This is not true of singleton selects as sub-queries though: select ... where fieldname = (select ...); In this case, the sub-query must return exactly one row (and one column). An empty sub-query is not treated as \"null\". A runtime exception is raised.

Also, why does it say \"a valid insert statement\" for something that\'s just a select?

Contributed by Lovely on 3 September 2012 03:08 AM

Denny,There IS a bug in the incrementing of the major verosin. I\'ve fixed it in SVN, but haven\'t made a new public release with the fix (one more entry on my list of things to do \"sometime\"). Since the major verosin only updates between migrations, the bug can only manifest itself if there is an issue with the first step of a given migration, but you\'re right, there is an issue there. The minor verosins (steps within a migration) are double protected: the increment happens second, and the whole thing is wrapped in a CFTRANSACTION. The reason the major verosin increments first is for internal bookkeeping reasons. It\'s safe for it to increment even if the first migration step fails, because it\'ll be minor verosin zero (which means the first step is still next in line). The bug was in when the minor verosin was reset to zero; it happened at the wrong time before.For the two-developer conflict scenario, there\'s nothing the tool can do about it. You have to resolve the conflicts when the second developer commits his/her changes. Migration code does have some ordering ramifications, so resolving a conflict might not be as simple as otherwise (quite possibly requiring manual tweaks to the `schema_verosin` table), but it\'s really no different from any other conflict between multiple developers.

Contributed by cheap backlinks on 18 July 2014 07:13 PM

O6Hksg I cannot thank you enough for the article.Thanks Again. Really Great.

Contributed by crorkz on 16 January 2015 01:19 AM

MwSG14 Thank you, I\'ve recently been looking for info about this topic for ages and yours is the greatest I\'ve discovered so far. But, what about the conclusion? Are you sure about the source?

Contributed by crork service on 2 September 2015 06:02 PM

7aqoCc You ave made some good points there. I looked on the net for additional information about the issue and found most people will go along with your views on this site.

Contributed by here on 28 September 2015 07:33 AM

t2cxV5 This is really interesting, You are a very skilled blogger. I ave joined your feed and look forward to seeking more of your wonderful post. Also, I ave shared your website in my social networks!

Contributed by fiverr seo on 16 October 2015 11:42 AM

4NE9Qy Major thanks for the blog post.Thanks Again. Much obliged.

Contributed by crorkservice seo on 8 November 2015 08:17 PM

bMn9Ct Wow, fantastic weblog structure! How long have you been running a blog for? you made blogging glance easy. The entire look of your website is excellent, let alone the content!

Contributed by crorkservice fiverr on 28 November 2015 02:28 PM

K18Obh Wow, fantastic blog format! How long have you been blogging for? you made running a blog look easy. The full look of your web site is excellent, as well as the content!

Contributed by nbyCmUcZa on 31 December 2015 01:14 PM

76O4l1

Contributed by fiverr cocoservice on 1 March 2016 08:09 AM

HcWrm6 Thank you for this entry. Looking forward to next one.

Contributed by fiverr cocoservice on 30 March 2016 11:42 PM

NuFdrG Impressive how pleasurable it is to read this blog.

Contributed by fiverr photo on 6 April 2016 10:16 AM

2gwSK6 Im grateful for the blog article.Thanks Again. Much obliged.

Contributed by porn movies on 13 May 2016 08:59 PM

wow, awesome blog article. Keep writing.

Contributed by fuck your mom on 16 May 2016 04:07 AM

ABJ08N where do you buy grey goose jackets from

Contributed by huba buba on 4 August 2016 12:27 AM

RmBVwn I think this is a real great post.Thanks Again. Great.

Contributed by makarena on 10 October 2016 11:09 PM

4Ipknw You have made some good points there. I checked on the internet to find out more about the issue and found most people will go along with your views on this site.

Contributed by suba hentai on 27 November 2016 12:54 AM

cFhUX3 Keep up the excellent piece of work, I read few content on this internet site and I believe that your web blog is really interesting and has bands of excellent info.


Extend this topic - Post a comment

Your name:
Your comment:
This post is plain text
This post is html formatted