Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

spi_getargcount(3) [centos man page]

SPI_GETARGCOUNT(3)					  PostgreSQL 9.2.7 Documentation					SPI_GETARGCOUNT(3)

NAME
SPI_getargcount - return the number of arguments needed by a statement prepared by SPI_prepare SYNOPSIS
int SPI_getargcount(SPIPlanPtr plan) DESCRIPTION
SPI_getargcount returns the number of arguments needed to execute a statement prepared by SPI_prepare. ARGUMENTS
SPIPlanPtr plan prepared statement (returned by SPI_prepare) RETURN VALUE
The count of expected arguments for the plan. If the plan is NULL or invalid, SPI_result is set to SPI_ERROR_ARGUMENT and -1 is returned. PostgreSQL 9.2.7 2014-02-17 SPI_GETARGCOUNT(3)

Check Out this Related Man Page

SPI_EXECUTE_PLAN(3)					  PostgreSQL 9.2.7 Documentation				       SPI_EXECUTE_PLAN(3)

NAME
SPI_execute_plan - execute a statement prepared by SPI_prepare SYNOPSIS
int SPI_execute_plan(SPIPlanPtr plan, Datum * values, const char * nulls, bool read_only, long count) DESCRIPTION
SPI_execute_plan executes a statement prepared by SPI_prepare or one of its siblings. read_only and count have the same interpretation as in SPI_execute. ARGUMENTS
SPIPlanPtr plan prepared statement (returned by SPI_prepare) Datum * values An array of actual parameter values. Must have same length as the statement's number of arguments. const char * nulls An array describing which parameters are null. Must have same length as the statement's number of arguments. n indicates a null value (entry in values will be ignored); a space indicates a nonnull value (entry in values is valid). If nulls is NULL then SPI_execute_plan assumes that no parameters are null. bool read_only true for read-only execution long count maximum number of rows to return, or 0 for no limit RETURN VALUE
The return value is the same as for SPI_execute, with the following additional possible error (negative) results: SPI_ERROR_ARGUMENT if plan is NULL or invalid, or count is less than 0 SPI_ERROR_PARAM if values is NULL and plan was prepared with some parameters SPI_processed and SPI_tuptable are set as in SPI_execute if successful. PostgreSQL 9.2.7 2014-02-17 SPI_EXECUTE_PLAN(3)
Man Page

15 More Discussions You Might Find Interesting

1. Fedora

Is UNIX an open source OS ?

Hi everyone, I know the following questions are noobish questions but I am asking them because I am confused about the basics of history behind UNIX and LINUX. Ok onto business, my questions are-: Was/Is UNIX ever an open source operating system ? If UNIX was... (21 Replies)
Discussion started by: sreyan32
21 Replies

2. UNIX for Beginners Questions & Answers

Weird 'find' results

Hello and thanks in advance for any help anyone can offer me I'm trying to learn the find command and thought I was understanding it... Apparently I was wrong. I was doing compound searches and I started getting weird results with the -size test. I was trying to do a search on a 1G file owned by... (14 Replies)
Discussion started by: bodisha
14 Replies

3. UNIX for Beginners Questions & Answers

Set hard block limit for user using quota

hi all, i have installed quota on my centos 7 machine and its what im after (setting size limit on users, so they cant fill the hard drive) i want to now make this part of my create user script for my sftp server so i want to do a echo and a read command so i capture the limit they enter... (0 Replies)
Discussion started by: robertkwild
0 Replies

4. UNIX for Beginners Questions & Answers

Best performance UNIX just for HOST Virtualization?

Hi everybody, Which Unix base OS have best performance for HOST virtualization? I tested SmartOS but it needs another OS to connect remotely! Thanks in advance. (11 Replies)
Discussion started by: mbzadegan
11 Replies

5. UNIX for Beginners Questions & Answers

How to increment version inside a file?

Hi All, I need to write a shell script which opens a file and increments the version(text) within the file every time the script runs. For example: $ cat docker_file.yml version: '3.1' services: ui: image: repo-srv.dev.io:5000/facebook/ui:0.0.2-QA1 $ So, I would like... (6 Replies)
Discussion started by: akshayupadhayay
6 Replies

6. Programming

DB2 convert digits to binary format

Dear Team We use DB2 v10.5 and using DBArtisan tool Can someone please guide how to convert digits to binary numbers using db2 feature. Ex> for number 9 , binary should be 1001 ( 8+1) Any help appreciated. Thanks (2 Replies)
Discussion started by: Perlbaby
2 Replies

7. UNIX for Advanced & Expert Users

Tar Command

hi folks, how to using tar with exclude directory and compress it using tar.Z i only know how to exclude dir only with this command below: tar -cvf /varios/restore/test.tar -X excludefile.txt /jfma/test1/ how to compress it using 1 command? Thanx Please use CODE tags as... (6 Replies)
Discussion started by: only
6 Replies

8. UNIX for Advanced & Expert Users

CentOS7 restoring file capabilities

Quite an obscure question I think. We have a rebuild process for remote sites that allows us to PXE rebuild a till (actually a PC with a touch screen and various fancy bits) running CentOS. The current CentOS5 tills work just fine with a tar image restore and some personalisation. Sadly,... (4 Replies)
Discussion started by: rbatte1
4 Replies

9. Docker

Docker learning Phase-I

Hello All, I had recently learnt a bit of Docker(which provides containerization process). Here are some of my learning points from it. Let us start first with very basic question: What is Docker: Docker is a platform for sysadmins and developers to DEPLOY, DEVELOP and RUN applications ... (7 Replies)
Discussion started by: RavinderSingh13
7 Replies

10. UNIX for Advanced & Expert Users

Shopt -s histappend

What is the point of this? Whenever I close my shell it appends to the history file without adding this. I have never seen it overwrite my history file. # When the shell exits, append to the history file instead of overwriting it shopt -s histappend (3 Replies)
Discussion started by: cokedude
3 Replies

11. UNIX for Beginners Questions & Answers

Unsure why access time on a directory change isn't changing

Hello... And thanks in advance for any help anyone can offer me I was trying to work out the differences between displaying modify, access, and change times with the 'ls' command. Everything seems in order when I look at files, but the access time on a directory doesn't seem to change when I... (4 Replies)
Discussion started by: bodisha
4 Replies

12. UNIX for Beginners Questions & Answers

CentOS 6 ran out of space, need to reclaim it

Hello everyone, I am having an issue here with CentOS release 6.6 (Final) that shows all of the space used up, but I can't tell where the space went. Seemingly I am using up 100%, according to df -h Filesystem Size Used Avail Use% Mounted on... (27 Replies)
Discussion started by: DannyBoyCentOS
27 Replies

13. Shell Programming and Scripting

Controlling user input

I'm trying to use a bash script for a psych experiment that involves listening to sound files and responding. If I have something like the code below, how can I make sure that a key press is assigned to RESPONSE only after the second echo statement? for i in 1 2 3; do echo "Ready?" sleep 2 ... (10 Replies)
Discussion started by: darwin_886
10 Replies

14. Shell Programming and Scripting

[TIP] Processing YAML files with yq

After the success of the jq - tool for parsing and manipulating JSON-Data someone wrote a tool called yq, which aims to be the same for YAML, what jq is for JSON. Seems to work fine. I'll definitely give it a chance in future. Example YAML-File: --- !ruby/object:Puppet::Node::Facts ... (1 Reply)
Discussion started by: stomp
1 Replies

15. What is on Your Mind?

Please Welcome Dave Munro to the Moderator Team!

Dear All, I am very pleased to announce that Dave Munro (gull04) is joining the Moderation Team, after being a very valuable member of UNIX.com for 15+ years. Dave is an IT Consultant with 30 years of experience this year, has worked in many of the industry vertical market segments and has... (6 Replies)
Discussion started by: Neo
6 Replies