Type Alias BindWithName

BindWithName: BindParameter & { name: string }

Provides the ability to Bind a parameter with a name that will be used

This is very useful for the output values

Example

const title = 'Good Omens';
const author = 'Terry Pratchett & Neil Gaiman';
const pages = 288;
const bind = {
  name: 'id',
  dir: BIND_OUT,
  type: NUMBER,
};
const query = sql`INSERT INTO books (TITLE, AUTHOR, PAGES)
                             VALUES (${title}, ${author}, ${pages})
                  RETURNING ID into (${bind})`;

Type Alias BindWithName

Example

Settings