Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql-procedure]

The tag has no usage guidance.

0
votes
1answer
28 views

Pull multiple fields from table B where a specific value from Table A is not in Table B

SQL Newbie here. I have a question about pulling multiple fields from a database when one value is not in another table. I have two tables: "Contact" table - contains all of our contact information ...
1
vote
1answer
46 views

How to use variables in procedure (not function)? [closed]

As I understand, in Postgres, procedures are for manipulating data and functions are for reading data. I would like to: declare a variable select a value into a variable insert the variable into ...
3
votes
1answer
510 views

“column … does not exist” error when calling an SQL procedure (new in PostgreSQL 11)

Using PostgreSQL 11 Beta 2, a very simple trading_holiday table is created in the config schema: DROP TABLE IF EXISTS config.trading_holiday; CREATE TABLE config.trading_holiday ( id smallint ...