https://www.sqlines.com/ 2026-04-10T08:27:02+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2011-12-22T12:52:13+00:00 https://www.sqlines.com/postgresql/limit_offset?rev=1324558333&do=diff OFFSET and LIMIT options specify how many rows to skip from the beginning, and the maximum number of rows to return by a SQL SELECT statement. Quick Example: -- Return next 10 books starting from 11th (pagination, show results 11-20) SELECT * FROM books ORDER BY name OFFSET 10 LIMIT 10; text/html 2011-12-28T13:28:38+00:00 https://www.sqlines.com/postgresql/npgsql_cs_result_sets?rev=1325078918&do=diff Npgsql .NET Data Provider allows you to process result sets returned by a SELECT statement (query) a PostgreSQL function (stored procedure). * How to Return a Result Set from a Stored Procedure in PostgreSQL Query - Working with a Single Row Result Set in C# Quite often a result set contains just a single row and column, for example, when you obtain the result of SELECT COUNT(*) FROM ... or last generated ID using SELECT LASTVAL(); text/html 2011-12-27T12:54:56+00:00 https://www.sqlines.com/postgresql/npgsql_dotnet?rev=1324990496&do=diff Npgsql is an open source .NET Data Provider for PostgreSQL 9.x and 8.x. It allows you to access a PostgreSQL database from any .NET application. PostgreSQL 9.x and 8.x Microsoft .NET 4.0 and 3.5 Mono (open source .NET) C# and Visual Basic.NET ASP.NET and Web Services How to Install Npgsql Download the data provider at <http://pgfoundry.org/projects/npgsql> (BSD License). text/html 2012-01-21T05:44:57+00:00 https://www.sqlines.com/postgresql/oid?rev=1327124697&do=diff OID is auto-incrementing integer value, unique within a PostgreSQL database (not just a table) that can be automatically assigned to each row of a table created WITH OIDS option. Although OID can be used as an identity (auto-increment) primary key column, it is recommended to use SERIAL data type instead. For more information, see Generating IDs in PostgreSQL. text/html 2012-01-04T18:29:56+00:00 https://www.sqlines.com/postgresql/pgadmin?rev=1325701796&do=diff pgAdmin is the most popular development and administration GUI tool for PostgreSQL. pgAdmin Query Tool * How to Change Database in Query Tool text/html 2011-12-27T10:18:59+00:00 https://www.sqlines.com/postgresql/stored_procedures_functions?rev=1324981139&do=diff A stored procedure and user-defined function (UDF) is a set of SQL and procedural statements (declarations, assignments, loops, flow-of-control etc.) that stored on the database server and can be invoked using the SQL interface. Quick Example: -- Function increments the input value by 1 CREATE OR REPLACE FUNCTION increment(i INT) RETURNS INT AS $$ BEGIN RETURN i + 1; END; $$ LANGUAGE plpgsql; -- An example how to use the function (Returns: 11) SELECT incr… text/html 2024-06-26T16:18:32+00:00 https://www.sqlines.com/postgresql/zero_char_code_in_string?rev=1719418712&do=diff PostgreSQL does not allow you to insert the character with code zero (ASCII NUL) to CHAR, VARCHAR or TEXT columns regardless of the specific character set. For the example, the following INSERT statement fails: PostgreSQL: -- Sample table CREATE TABLE items ( c1 CHAR(10) ); INSERT INTO items VALUES ('a' || CHR(0) || 'b'); # ERROR: null character not permitted